I'm trying to make a popup that lists all record IDs from a table.

In Arev, we can use P (under Options) and @IDS

This is what I do in OI (but this is taking too long):

RLIST_STATEMENT=SELECT COMPANY_DB"

CALL RLIST(RLIST_STATEMENT,5,"","","")

FORMAT=0:10:C:L::Record ID"

	SWAP ":" WITH @SVM IN FORMAT

	POPUP_STRUCT          =NULL$

	POPUP_STRUCT  =COMPANY_DB"

	POPUP_STRUCT= 0

	POPUP_STRUCT=2

	POPUP_STRUCT=FORMAT

	POPUP_STRUCT  =C'

	CHOICE=POPUP(@WINDOW,POPUP_STRUCT,'')

Any other options that can just list the record IDs in a popup ?

Rudhy

Two ideas pop in ..

1) Open the table, then select then build/display your popup.

2) I tend to create the popups in the UI Workspace. a) This way they can be reused without having to code in multiple locations and b) you can test you popup easily before trying to use. Use the 'select rows from table' without the use of a selection criteria.

dsig@sigafoos.org.com onmouseover=window.status=the new revelation technology .. a refreshing change;return(true)"

David Tod Sigafoos ~ SigSolutions

Phone: 971-570-2005

OS: Win2k sp2 (5.00.2195)

OI: 4.1

That's what I have to do now. I select the tablename first. But the Select statement is taking time. Whereas, in Arev, using @IDS, the result is instantaneous, before there is no select.

Rudhy

Rudhy,

Did you follow DSig's last point? He suggested removing the selection criteria (i.e. no "BY @ID" and no RLIST statement). That will display your popup immediately like AREV does. However, it will not be sorted.

If you really want a sorted list and a quick displaying popup then I recommend a Quickdex/Rightdex on your table. That way instead of an RLIST statement you can simply read the keys from the %RECORD% row and use the Make.List routine to create an active select list.

dbakke@srpcs.com

SRP Computer Solutions, Inc.

Now I get it :)

Thanks,

Rudhy

View this thread on the Works forum...