Home » Developer & Programmer » Forms » how to change list item value programmatically (forms 6i)
how to change list item value programmatically [message #485082] Mon, 06 December 2010 02:03
nasir_mughal
Messages: 122
Registered: April 2007
Location: Karachi
Senior Member
Hi

I am using a record group to populate list item with this query.


SELECT INSP_NAME,INSPECTOR_ID
FROM   INSPECTOR_ID
WHERE  BRANCH_ID=:PARAMETER.BRANCH_ID
ORDER BY INSP_NAME



And using this code on WHEN-NEW-FORM-INSTANCE trigger to populate list item.


DECLARE
	rg_id RECORDGROUP;
	p_list NUMBER;
BEGIN
	rg_id:=FIND_GROUP('INSP');
	p_list:=POPULATE_GROUP(RG_ID);
	POPULATE_LIST('TOOLBAR.INSP_ID',RG_ID);
END;	



I have created a button on the canvas, I want whenever user presses this button next value/element should be selected in the list item, if current element is the last one then first element should be selected. And after that WHEN-LIST-CHANGED trigger should be fired.

What code should I use behind WHEN-BUTTON-PRESSED.

Thanks in advance.
Previous Topic: ORDER SIBLINGS not working in Forms
Next Topic: default & smartbar
Goto Forum:
  


Current Time: Thu Sep 19 13:48:57 CDT 2024