Skip to Main Content

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

display multiple records in control block's text item

431188Oct 14 2004 — edited Apr 4 2005
Hi
I am trying to display many distinct records, from a post-query trigger, into a non-database item in a control block.
My situation is as follows :
I have a form based on one database table. This table has a FK link to another table on the column Prov_ID. To insert records into my table , I have created a LOV which does a select on the seperate table that is referenced by my FK. This then populates the FK column in my form-based table with the correct value.
For display purposes , I have created a control block which I have linked to the LOV, so that when users select a value from the LOV , the description displays in the control block's item , and the Prov_ID column gets populated in the background.
My problem lies with querying after inserting records into this form.
Although I am able to query records when i specify some query criteria, I am not able to retrieve all the records when I query with no search criteria.
I have tried creating a post-query trigger to populate my control block's display item with the correct value , but this does not work when i am searching for all records.
Any suggestions.....?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 2 2005
Added on Oct 14 2004
16 comments
1,142 views