Make.List allows you to take a variable containing a list of keys separate by @fm and make it into a cursor.

How does one take a saved list or a cursor and save it to a variable containing a list of keys separated appropriately?

Ed Plummer

*–

* With an active cursor for myfile

* To load the (<64k) keys to a variable

*–

keys='

done='

loop

readnext key else done=1

Until done

 keys:=key:@FM

Repeat

keys-1,1 ='

*–

* To save the list to SYSLISTS, MYKEYS

*–

$INSERT RLIST_EQUATES

CALL RLIST('SELECT MYFILE',TARGET_SAVELIST$,'MYKEYS',,)

*–

* To Activate that list again

*–

declare subroutine Activate_Save_Select

$insert Logical

Activate_Save_Select("MYKEYS")

if Get_Status() else

EOF=FALSE$

loop

  readnext Key else EOF=TRUE$

until EOF

  gosub ProcessEntity

repeat

end

Hope this helps

Bob Carten

WinWin Solutions, Inc.

Orlay,

I hybrid alternative would be to save the list and then read the record from the SYSLISTS table.

dbakke@srpcs.com

SRP Computer Solutions

True.

You'd need to know to strip the SYSLIST header (depending upon you version of OI you may not have one), and to read multiple SYSLIST records byt checking for id, id*2, id*3, etc.

Mike Ruane

Ed,

You should also check out the following in the help file:

Save_Select

Activate_Save_Select

Delete_Save_Select

It is best not to try to manipulate cursor information in a variable, as tempting as it may seem. The primary reason is that a cursor can exceed 64k, and if you try to collect ] 64k, you will get a VEML. If you are certain the list will never exceed 64k, then it is not a problem.

Cameron Purdy

Revelation Software

View this thread on the Works forum...