Kindly advice how to do this in form6i on EBS11i
after I execute_query in :BLK1 then my intention is to populate another record from view A and append to the last record of the execute_query. I confusing when try go_block to last record and fetch in POST-QUERY and lots of limitation thrown out.
which is best trigger to put code and sample or little of pseudo code is very thankful.
Big thanks in advance!!
just my input after tried many way. this cannot be done. So what I did is after execute_query return data, I create 1 button for user to click then trigger 'WHEN-BUTTON-PRESS' will fetch another set of record append to them. no automatic solution in 1 shot.
As per your notes, it seems that both query/structure having same structure, if so , for both query - create new view based on both query(single query) - so that user will get data on single trip/way,
Hope it will help u
Edited by: O.Developer on Dec 19, 2012 8:44 AM
thanks O.developer. That's another solution I tried
Even if 2 portion recordset can sharing the same structure which I can create in single view. But my problem is my second part of new record set is using where cause which is primary is not database item. for example
:BLK1 have 4 item. item 1,2,3 is DB column=Y and item 4 is none database.
I tried create view and execute_query return
1st record return from query using where cause item 1 = '1001'
2nd record is another using where cause item 4 = 'ABC'
when I commit form. the 2nd recordset thrown error like primary key issue in database block. Can you advice this?
Edited by: Jarjarbank on Dec 18, 2012 11:58 PM