Home » Developer & Programmer » Forms » list box 3
list box 3 [message #157288] Wed, 01 February 2006 07:39 Go to next message
eswaries
Messages: 41
Registered: January 2006
Member
how can i delete all the items in the list box at run time?
Re: list box 3 [message #157783 is a reply to message #157288] Mon, 06 February 2006 00:44 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
I have not done this but you could try by using 'delete_group' and then do a 'create_group' that returns no rows.

David
Re: list box 3 [message #157846 is a reply to message #157783] Mon, 06 February 2006 12:27 Go to previous message
RJ.Zijlstra
Messages: 104
Registered: December 2005
Location: Netherlands - IJmuiden
Senior Member
as an alternative, straight from the 'Help':

/*

** Built-in: POPULATE_LIST
** Example: Retrieves the values from the current list item
** into record group one, clears the list, and
** populates the list with values from record group
** two when a button is pressed.
** Trigger: When-Button-Pressed
*/
BEGIN
Retrieve_List(list_id, 'RECGRP_ONE');
Clear_List(list_id);
Populate_List(list_id, 'RECGRP_TWO');
END;

Just do not do the last populate-group. Whit a bit of code you can now keep your record-group for when you need it again.

HTH,
Previous Topic: Not showing PL/SQL editor
Next Topic: Control The Quantity
Goto Forum:
  


Current Time: Fri Sep 20 06:45:14 CDT 2024