Home » Developer & Programmer » Forms » Populate listbox in the Post-Query trigger
Populate listbox in the Post-Query trigger [message #232363] Fri, 20 April 2007 05:11 Go to next message
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 #232369 is a reply to message #232363] Fri, 20 April 2007 05:36 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
Have you tried a LOV? That's perhaps more appropriate.

MHE
Re: Populate listbox in the Post-Query trigger [message #232371 is a reply to message #232369] Fri, 20 April 2007 05:44 Go to previous messageGo to next message
tomek1042
Messages: 2
Registered: April 2007
Junior Member
I have tried. It works, but there is 2 or 3 only items in my list so I would rather prefer a listbox.
Re: Populate listbox in the Post-Query trigger [message #232652 is a reply to message #232371] Sun, 22 April 2007 20:50 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT 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
Previous Topic: Updations of table when table is updated
Next Topic: Request for Project!!
Goto Forum:
  


Current Time: Mon Dec 05 23:52:27 CST 2016

Total time taken to generate the page: 0.09033 seconds