How To Make Sure Checkbox Checked Or Not

Apr 19, 2007

On a page I have let's say 5 rows (can be more or less) and each row ends with a checkbox. On the next page(next prcodure) I go through all rows, but I get a "No data found" when a checkbox is not checked. Checkbox's parametre is send using an array.How can I make sure is a checkbox checked or not. If it's not, I put a formHidden through in it's place?

View 1 Replies


ADVERTISEMENT

Application Express :: How To Check If The Checkbox Is Checked

Oct 24, 2012

I am running blank with this one.

I have a checkbox item called P46_PAGE2 with static LOV STATIC:;1

How do I check if it is check using Javascript.

View 2 Replies View Related

Forms :: Unable To Insert Checkbox Checked Records?

May 23, 2011

I have a multi-record block with a check box(:B_ASTHEAD.CB_CHECK) for each record. user can select the record by clicking on the check box. when checked, value is 'Y' and when unchecked, value is 'N'.

when user clicks on 'OK' button (when button pressed trigger), the records which are selected(Checkbox) must be posted to the database table.

L_last_Rec number;
L_first_Rec number;
L_AST COP_DETL.AST%TYPE;
BEGIN

[Code]....

The issue here is , check box selected records are not getting inserted into table when OK button is clicked and i could see that all checked checkboxes become unchecked immediately . But if i comment the --"if :B_ASTHEAD.CB_CHECK = 'Y' then " part, then insert works , but inserts all record.

Insert only checkbox selected records.

View 11 Replies View Related

Forms :: Checkbox Checked On Runtime And Store In Global Variable

Feb 6, 2010

I have more then one checkbox on my form,I want to get which one is checked on runtime and store it in global variable?

View 6 Replies View Related

Forms :: How To Count Checked Checkboxes Along With Their Checked And Unchecked Condition

Nov 1, 2012

i want to count how many check boxes are chechked and if the check box is unchecked the count will decrease as soon as checkbox is check or uncheck.the number of chech boxes are depentdent on record set that are fetched from database.

View 2 Replies View Related

Application Express :: Retain Checkbox Value On Cascading LOV Checkbox

Sep 29, 2012

My development instance's APEx version is 4.1. I have two checkbox items works on cascading LOV. The cascading works very well as long as if I do not come back and check anything from the first checkbox item after I checked the second checkbox.

If I do, the cascade LOV refresh uncheck all checked values from the second box. My question is, how can I preserve the second check boxes checked values before refresh?

View 0 Replies View Related

Forms :: Insert Records Which Are Checked

Jul 7, 2011

I am working on form builder 6i. I have multi record datablock 't1'.' I have 'Submit' Button, which contains 'commit_form'. I am able to insert records.

Now i have a check box in data block, i want to insert records which are checked. I followed below thing to achieve that.

ON-INSERT Trigger:

If check_box ='Y' THEN
INSERT_RECORD
end if.

SUBMIT BUTTON: commit_form.

Let us say, i have 5 records, 2 records are checked, after clicking SUBMIT button, it's inserting 2 records only. But in console window, it's showing '5 transactions are saved'. I want see '2 transactions are saved' message in console window.

How to get it or any other solution which will insert records which are checked and show correct message in console window.

View 11 Replies View Related

SQL & PL/SQL :: What Stage Update Data Will Be Checked

Aug 13, 2010

Constraint_type = UNIQUE

If I'm updating a value from 10000 to 555555. And the constraint's status is ENABLED Deferred is IMMEDIATE.

Now my question is at what stage the updating data will be checked?At the entry level or at end of the Updation statement?

View 5 Replies View Related

RAC & Failsafe :: Interface Eth0 Checked Failed

Jun 21, 2012

I have installad oracle 10g RAC on centos properly and it was running properly few days before.

But today when I am trying to start oracle RAC services. it is showing error. and VIP service is not starting.

[root@rac1 racg]# crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora....C1.inst application ONLINE OFFLINE
ora....C2.inst application ONLINE OFFLINE
ora.RAC.db application ONLINE UNKNOWN rac1
ora....SM1.asm application ONLINE UNKNOWN rac1

[code].....

After google this I found an error in vip log file which is as follows

2012-06-21 13:16:36.720: [ RACG][3067987648] [5015][3067987648][ora.rac2.vip]: clsrcexecut: env ORACLE_CONFIG_HOME=/u01/app/crs/product/10.2.0/crs
2012-06-21 13:16:36.720: [ RACG][3067987648] [5015][3067987648][ora.rac2.vip]: clsrcexecut: cmd = /u01/app/crs/product/10.2.0/crs/bin/racgeut -e _USR_ORA_DEBUG=0 54 /u01/app/crs/product/10.2.0/crs/bin/racgvip start rac2
2012-06-21 13:16:36.720: [ RACG][3067987648] [5015][3067987648][ora.rac2.vip]: clsrcexecut: rc = 1, time = 5.910s

[code].....

View 4 Replies View Related

Forms :: FRM-30187 - Checked All Fields On RG Query

Aug 1, 2008

I got that error bur I checked all the fields on RG query and they are not more 300 char in total. Even I changed the query but I still get this error.

View 2 Replies View Related

Forms :: How To Insert Records Checked In Multi Record Block

Jun 29, 2011

I am working on forms 6i.

I have datablock 'EMP', it's multi record block. I have a button 'CREATE', I have 'commit_form' in 'When button pressed' trigger, to commit records. It's working fine.

Now, i have a check box in the same block, i want to insert records which are checked only.

View 7 Replies View Related

Application Express :: How To Determine Which Tabular Form Check Box(es) Are Checked

Oct 1, 2012

I'd like to determine (from code defined in a button definition) which check box(es) on a Tabular Form are checked. Assuming only one check box is checked, I want to obtain one of the values in that row for further processing. How to interrogate the Tabular Form to find out which box is checked?

View 9 Replies View Related

Application Express :: Get Checked Options Values Via Application Global Arrays?

Apr 26, 2013

how to use checkbox item, and trying to get checked options values via application global arrays. So, this may be quite simple question, but I'm completely stuck here...

When I was looking through various threads and guides, I've encountered checkbox corresponding array names like "g_f01" - "g_f50". And so far i saw that these names are derived from item name in generated HTML code, for example:

<input type="checkbox" name="*f10*" value="3" />

And this one stands for array name "g_*f10*".However, when I tried to do the same thing - i receive item name which looks like "*p_v04*", and therefore, I can't figure out, which array name should I choose to adress it properly.

My generated HTML snippet:

<input type="checkbox" id="P6_ANSWER_0" name="*p_v04*" value="3"/>

View 2 Replies View Related

Forms :: Checkbox Value Insertion In Table

Nov 4, 2010

I am using oracle form builder 6i and oracle database 10g

1:I have table named 'info' column name 'InfoId'and some other.And another table named 'Handing' with column names HtId, Value1 and value2.

2:I made form that consist of three data blocks, first block takes criteria and second block display record against that criteria from table 'info'.

3:i want checkboxes agianst that display record,and want that when I select some checkboxes against 'InfoId' these selected 'InfoIds'

should save in another table named 'handing' in column 'HtId'.and in same table data in column value1 and value2 will be inserted through textboxes that are in the third datablock of the thae same form .

View 2 Replies View Related

Forms :: Looping Records With Checkbox Value

Jun 17, 2013

I am Using the Check Box in the Detailed Block & I Have Assigned values 'Y' and 'N' when Checked & Unchecked If there are 3 Values Retrieved in the Detailed Block, Among that 2 Values are Checked the Cursor is Directly going the 2nd Value and Displaying the 2nd Value 2 Times rather than Displaying the 1st Value.

Below Attached is the Code Which i am Using.

GO_BLOCK ('ITEM_RESULT');
L_ITEM_CODE := :ITEM_RESULT.ITEM_CODE;--71720;--
first_record;
loop
message (' item id is '|| L_ITEM_CODE || '-' || :ITEM_RESULT.CHECKBOX);
if L_ITEM_CODE is not null and :ITEM_RESULT.CHECKBOX = 'Y' then
begin
[code]....

View 6 Replies View Related

Forms :: Want To Check For Checkbox Status With One More Corresponding Value

Aug 3, 2011

I was working with forms and found a problem related to accessing of status of checkbox. In a block with multi record to be checked, if we want to check all the checkbox status which is already clicked, Then what should i do.

Now i am using the function Checkbox_check as:

if Checkbox_Checked('FVA.STATUS')

But the problem with this function, it is giving status of last clicked checkbox only.

View 17 Replies View Related

Forms :: No Of Checkbox Clicked At A Time?

Oct 28, 2010

I have a data block which contain no. of records displayed e.g 10 record...In That data block i used checkbox

My Requirement is when i click Select all checkbox , No. of checkbox record shown click mark..how to do that.

View 3 Replies View Related

Application Express :: Getting Values Of Checkbox

Sep 4, 2012

I have problem with getting values of checkbox. I have search page where are some numbers field, date pickers, radio buttons and checkbox (P40_ OE) when I click search button I want to get report with filters like

select t1.id, t1.name, t1.company
from table1 t1, table2 t2
where t2.id = t1.id
and t2.oe in list of values from P40_OEIn checkbox I have 11 options to choose. I work in Apex 4.1.

How can I make this search or filter report working?

View 2 Replies View Related

Forms :: CheckBox Controls Column Values?

Aug 2, 2012

I have a custom form build on Oracle Forms Builder 6i. It is divided into tow tabs I have to place a checkbox on tab 1 and control the values of a column present on tab2. When the checkbox is ticked the values in column should be 'X' and if the checkbox in unchecked all the values should be changed to 'Y'.

View 3 Replies View Related

Forms :: Checkbox In Multi-row Block And Scroll Bar

Oct 17, 2008

I have a multi row datablock with scroll bar. In each record I have a checkbox (let's call it check_record), and above these checkboxes, there is a checkbox to check/uncheck all the checkboxes (let's call it check_all).

If all the "check_record" are checked, the "check_all" must be automatically checked, else if one "check_record" is not checked, it will be unchecked.

To do that, I have put a loop in the WHEN-CHECKBOX-CHANGED of "check_record" to loop over all the "check_record" and see if they are checked or not.

Normally, this loop will automatically go to last record. But to go back to the selected record (where the "check_record" was clicked), I have used go_record with the record ID.

==> No problem in that, it's working fine.

Now, this is my problem: When clicking on a "check_record", the scroll bar moves to show the selected row in the first (or last) VISIBLE row in the data block, and that's because of using "GO_RECORD(<CURRENT_RECORD>)".

Example: if I select the third record in the data block, the scroll bar moves to show it in the first visible row.

Is there a way to "freeze" the scroll bar and keep the record in its initial position in the data block?

View 7 Replies View Related

Forms :: Change Total Based On Checkbox Value

Jun 25, 2013

I have created a custom form which fetches certain records. There is a column called invoice_create_flag which is check box. By default when we query this form, value of check box is 'Y'. Another column is Amount.

Initially when form is called, all the records are selected. Hence it should show the total of all the records. Now If the users unchecks any record, System should deduct the amount of that particular record from the total amount.

Attached is form screenshot for reference.

View 1 Replies View Related

Forms :: Add Checkbox With Hierarchical Tree Node

Jun 10, 2011

I am using oracle forms 9i. I have to create a Hierarchical Tree and attach checkbox at its node,so that user can select which tree he want in its further processing.

View 4 Replies View Related

Forms :: Oracle Checkbox / Submit Button?

Aug 1, 2012

My requirement is I have placed a check Box in the Detailed Block and i have assigned values for the check box as

Checked - R
Unchecked - P
Initial Value - R

by default the check box would be displayed as Checked while inserting the values in to table the value of check box is not getting inserted but when the check box is unchecked the the value is getting inserted as P when the submit button is pressed.

View 11 Replies View Related

Application Express :: Checkbox On Click Action

Jan 15, 2013

I am working in apex 4.2.1.

I'm having an odd problem with a checkbox on a tabular form. I created the checkbox by setting hte display as to "Simple Checkbox". The value of the underlying column sets to "Y" wehn checked and "N" when unchecked. This is what I want. The next thing I was trying to accomplish is to call a javascript function when the checkbox is clicked. So I put onclick="calculateTotal(this);" in the element attributes field. The code that it is calling is listed below. When I run the app and check the box I can seee I am entering the calculate Total function. Each of the alert functions is displaying what I would expect until I get to alerts 'IAH5' and 'IAH6'. For each of those I get an "undefined" in the alert.

So to see if this had something to do with the checkbox and added an onchange="calculateTotal(this);" to another field in my tabular form and ran it. This time I did not click on the checkbox but went into the field that I put the onchange on. When I changed this field and navigated away from it the function worked as I would expect. It displayed the appropriate values for each of the alerts and updated the fields on the screen as designed.

<script type="text/javascript">
function calculateTotal(pThis)
{
alert('IAH1');
var vRow = pThis.id.substr(pThis.id.indexOf('_')+1);
alert('IAH2');
[code].......

View 6 Replies View Related

Application Express :: Checkbox Corresponding Global Array Name?

May 27, 2013

m learning how to use checkbox item, and trying to get checked options values via application global arrays. So, this may be quite simple question, but I'm completely stuck here...When I was looking through various threads and guides, I've encountered checkbox corresponding array names like "g_f01" - "g_f50". And so far i saw that these names are derived from item name in generated HTML code, for example:

<input type="checkbox" name="*f10*" value="3" />

And this one stands for array name "g_*f10*".

However, when I tried to do the same thing - i receive item name which looks like "*p_v04*", and therefore, I can't figure out, which array name should I choose to adress it properly :(

My generated HTML snippet:

<input type="checkbox" id="P6_ANSWER_0" name="*p_v04*" value="3"/>

View 4 Replies View Related

Application Express :: Checkbox In Classic Report

Jul 16, 2012

I have question about checkbox in classic report. I need to choose only one checkbox in every row, hot to ensure that only one checkbox can be checked at same time?

Checkboxes are defined in SQL query as:

apex_item.checkbox(1,msisdn,'UNCHECKED') as clear,
apex_item.checkbox(2,msisdn,'UNCHECKED') as to_analysis,
apex_item.checkbox(3,msisdn,'UNCHECKED') as to_barring

here is the picture:

[URL]........

View 9 Replies View Related

Application Express :: Difference Between JavaScript And Checkbox

Nov 18, 2013

How to check off checkbox with JavaScript. I tried

1) $("#checkboxID").prop('checked' , false) (jQuery)
2)    $("#checkboxID").attr('checked' , false) (jQuery)2) document.getElementById("checkboxID").checked = false;Checkbox's list of values: STATIC:;1

Checkbox always states checked. When I append 'checked="checked" ' attribute (or simply checked) to this unchecked checkbox in Firebug nothing happens. Why ? I execute JavaScript code in Dynamic Action on button click. All other controls (textareas and textfields) are cleaned successfully except this checkbox. "Effected elements" property includes all needed items.

View 3 Replies View Related

Application Express :: Checkbox Not Clear Cache

Oct 18, 2013

i have created form with table  page to enter hotel details there is on 6 check box which are not database column .i have create these check box to keep days details when hotel give service .so i have use

LOV FORP1_MON      STATIC2:;1   MONDAYP1_TUE       STATIC2:;2   TUESDAYP1_WED     STATIC2:;3   WEDNESDAYP1_THR       STATIC2:;4  THURSDAYP1_FRI        STATIC2:;5   FRIDAYP1_SAT       STATIC2:;6   SATURDAYP1_SUN       STATIC2:;7   SUNDAY 

i have one more column operating days where i have use computaation to keep operating days.

:P1_MON||:P1_TUS||:P1_WED||:P1_THR||:P1_FRI||:P1_SAT||:P1_SUN 

these 6 check box are used Source used :Only when curren value in session state is nullSource Type : Static Assignment (Value equals source attibute)  Problem are when i create new record then these 6 check box are not clear cache and when i update any record value are not clear cache . i need when i create or update recor then all 6 check box should be null after keep recor. 

View 1 Replies View Related

Application Express :: Retrieve All Data From One Multiple Checkbox To Another?

Jul 11, 2012

How do you retrieve all data from one multiple checkbox to another? The method I'm using returns one choice even though multiple have been chosen.

View 2 Replies View Related

Forms :: Uncheck Checkbox In Multi-record Block?

Sep 14, 2011

Could i uncheck the checked checkboxes in a mutirecord block by any command?

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved