| Populate listbox in the Post-Query trigger [message #232363] |
Fri, 20 April 2007 05:11  |
tomek1042
Messages: 2
Registered: April 2007
|
Junior Member |
|
|
How to populate database listbox field in the Post-Query trigger of block?
I tried to use ADD_LIST_ELEMENT and CLEAR_LIST. ADD_LIST_ELEMENT works but CLEAR_LIST fails, so it's useless.
I tried to use a record group with POPULATE_GROUP_WITH_QUERY and then POPULATE_LIST. Unfortunately POPULATE_LIST fails. There is no error code available.
Can anybody help me?
|
|
|
|
|
|
|
|
| Re: Populate listbox in the Post-Query trigger [message #232652 is a reply to message #232371] |
Sun, 22 April 2007 20:50  |
 |
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
|
Senior Member
Account Moderator |
|
|
Test the query that you have used for your LOV in SQL*Plus. Does it give the rows that you want displayed? If not, change it until it does. Use it in the LOV and you will have the rows that you want displayed.
David
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
