| to insert multirecord with check boxes [message #130018] |
Wed, 27 July 2005 13:13  |
prasadhbk
Messages: 2
Registered: July 2005
|
Junior Member |
|
|
Hi
Iam displaying the multi records from the data block. I have check boxes for each records.
If the check box is checked then the checked list should be inserted in to one table and the unchecked list should be inserted in to another table.
I have set the values when checked as 'Y' and unchecked as 'N'.
Written trigger in when check box changed . I can able to insert the checked list in to the table. but with unchecked one with my present code i have to check and uncheck the box, then only my code works for unchecked one and inserts those records into another table.
Here is my code in When Checkbox changed trigger.
if block_name.chkbox = 'Y' then
insert into table1(.....) values (....);
elsif block_name.chkbox = 'N'then
insert into table2(.....) values (....);
end if;
Any solution for me..
Regards
Prasad
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
