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
ADVERTISEMENT
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
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
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
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
View Related
Oct 7, 2012
I am getting this error FRM 40508 in inserting data to any table through forms 11g.
eg:
my test table having two columns : id and name
i wrote a simple insert statement insert into test values (:id, :name);
commit;
when i run the application and insert the values, it shows the above error.
when I use the display errors , it shows that there is a violation : ora - 00001 (duplicate values)
however, there is no such value in the database.
The same scenario is repeating with every table I have.
I thing more, when I use the commit_form only without using any manual insert statement, then everything goes well. But with manual insert it all fails.
View 3 Replies
View Related
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
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
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
Jul 2, 2011
how to display check box selected records in one column of form when push button is pressed.
View 1 Replies
View Related
Feb 20, 2009
I have inserted mathematical symbols e.g. quare root,pie etc etc. But when I come to query them they are represent by '?' mark.
View 5 Replies
View Related
Oct 16, 2012
I have this error. To put it simply I have two blocks.
Block1 contains two drop down list with PL/SQL statements for queries.
Block2 contains tabular form created from block wizard (I tried already in manual)
that will catch the result in Block1 queries.
Now I have a button with a trigger when-button-pressed that contains
BEGIN
INSERT INTO dummy1
VALUES ('hello',1,2,3);
COMMIT;
END;
My goal is to add into dummy1 values from :block2.item_name1, :block2.item_name2, :block2.item_name3 but to put it simply I tried these values but I received the same error.
When I run it and first things first click the button, the values will be added into dummy1 table but when I execute the block1 - dropdown list queries and try to press the button. I received the error.
View 10 Replies
View Related
Aug 30, 2013
I have a form with a datablock displaying 3 text item fields.But the actual oracle table have 8 columns.When ever I insert new data and save it, only the three records are being stored in backend whereas remaining column stores with null value.That is the basic function of the form.
I placed an another list item field in a control block which is non-database item.Now I want to store the list item value into a column along with the 3 columns.In a simple way, how to insert record manually along with the other records?
View 14 Replies
View Related
Jun 6, 2013
we unable to insert Georgian language in oracle forms and reports,while we insert it displasys as ? note my database characterset is utf8 and my Client PC NLS_char=american_america.utf8.
View 1 Replies
View Related
May 29, 2010
I want to update / insert records from one user to other user therefore I write this code in my form but it gives me error.
REPORT_DETAILS is a detail table of REPORT_PARAM, given code is working fine at master tables.
Form always goes in TOO_MANY_ROWS exception.
Correct my code, my requirement is: if data found then update else insert new record.
declare
cursor c1 is select * from factory_data.report_details order by rd_rp_id;
rec c1%rowtype;
v_check varchar2(1) := null;
begin
for rec in c1 loop
[code].......
View 7 Replies
View Related
Jan 14, 2013
I have an interface composed of five elements:
1.display_item (primary key)
2-list_item (foreign key) / / dynamic list :this is the cause of the error
3-lis_item (foreign key) / / dynamic list
4-text_item
5-button (insert commit)
when I click the button, an error is displayed:
FRM-40508: ORACLE error: unable to INSERT record.in detail: ora-02291 integrity constraint Violated - parent key not found
Note:
-the elements of two lists already exist in the parent table!!
-I use a block based.
-button
commit_form();
View 17 Replies
View Related
Oct 16, 2012
In a data block(it lists all the records created), I tried to search for the records which are created on a particular date. So I entered the date in query mode in that data block. But it is not returning any rows. But if I searched through other fields in that data block except that date data type it is returning the appropriate records.
View 10 Replies
View Related
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
Aug 31, 2011
I am working in form 6i, EBS11i. I have a multi record data block, i am inserting checked records only using below logic.
ON-INSERT Trigger:
if checkbox_checked('block.checkbox') THEN
insert_record;
end if;
Requirement: Let us say, i have 4 records, i checked 2 records.. inserted them. Now if i want to insert other 2 unchecked records, it's not accepting, is it possible to insert records which are not checked after insertion.
View 5 Replies
View Related
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
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
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
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
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
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
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
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
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
Sep 14, 2011
Could i uncheck the checked checkboxes in a mutirecord block by any command?
View 1 Replies
View Related
Dec 7, 2010
i m using oracle 10g 10.2.0.2 version.i create a form and using check box on this form.when i click this check box then loop is using behind it.and current cursor is going to last record
i want if i click 4 record then cursor is still showing on 4 record mean i click which record after using loopmy current cursor is showing on that particular record
how it is possible
View 1 Replies
View Related
