[[https://www.revelation.com/|Sign up on the Revelation Software website to have access to the most current content, and to be able to ask questions and get answers from the Revelation community]] ==== Command equivalent to GETLIST in AREV (OpenInsight Specific) ==== === At 01 NOV 2001 02:53:28PM leonshaf wrote: === {{tag>"OpenInsight Specific"}} Hi All... Working in OI, trying we have created saved a "list" in SYSLISTS, and we want to do the equivalent of a "GETLIST" in AREV to get this list from the SYSLISTS table. We have tried the following code, but still get zero records listed...any help would be appreciated.... CLEARSELECT RLID=QID:SID *Rlist("SELECT SYSLISTS",3,RLID,"","") RCMD=SELECT SYSLISTS WITH @ID=:QUOTE(RLID) Rlist(RCMD,5,"","","") CALL SLIST(RLS) If Get_Status(ErrCodes) Then GoSub ErrorHandling RETURN 1 Neither of the Rlist commands seem to return the values in an active list. We have verifed that the RLID exists in the SYSLIST table because we can open the System Editor, open record, SYSLISTS, and open the RLID in the SYSLISTS table and see the id's. TIA ---- === At 01 NOV 2001 03:55PM [url=http://www.sprezzatura.com" onMouseOver=window.status=Click here to visit our web site?';return(true)]The Sprezzatura Group[/url] wrote: === Leon You need to use the Activate_Save_Select subroutine (see online documentation - type this into the system editor then press F1). [url=http://www.sprezzatura.com" ]The Sprezzatura Group[/url] [i]World Leaders in all things RevSoft[/i] [img]http://www.sprezzatura.com/zz.gif[/img] ---- === At 01 NOV 2001 04:58PM leonshaf wrote: === Thanks Sprez's... Worked like a champ... [[https://www.revelation.com/revweb/oecgi4p.php/O4W_HANDOFF?DESTN=O4W_RUN_FORM&INQID=NONWORKS_READ&SUMMARY=1&KEY=0551061E67B2288D85256AF70067C5FC|View this thread on the forum...]]