Is possible to insert unchecked records after first insertion in multi record block [message #521578] |
Wed, 31 August 2011 05:31 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/9fc2c55773e60a8cef395fa8cb47a31f?s=64&d=mm&r=g) |
goparaju
Messages: 54 Registered: June 2011
|
Member |
|
|
Hi Experts,
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.
Kindly help.
Thanks.
|
|
|
|
|
|
|
Re: Is possible to insert unchecked records after first insertion in multi record block [message #521609 is a reply to message #521598] |
Wed, 31 August 2011 09:17 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/72104.gif) |
Littlefoot
Messages: 21818 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
You said that you want to insert checked records only. In order to do that, you wrote some code that is doing that job.
There are 4 records; you check 2 of them, do *something* (push a button?) and insert these checked records.
Now you want to insert the remaining 2 records, that are still unchecked.
So check them first, do *something* (push a button?) and insert them just like you inserted previous 2 records.
That might require some additional actions, such as requerying the block (so that the first 2 records won't appear, otherwise - if they are still checked, you'd insert them twice). Or, after insert is done, clear checkboxes. Or, include additional column that would notify you whether these records are already inserted. Or, before insert, check whether a record you are about to insert already exists in a table. Or, ...
|
|
|