Is there any way to take an arbitrary piece of data in a variable and have AREV think of it as the active select list? I can be certain that the data will never exceed 64K.

The only solution I've got is saving it to a temp table and doing a GET-LIST on it. But I find writing to disk just to assign something to memory especially aesthetically displeasing.

Sorry, put this in the wrong discussion group. Should be under AREV.

Jared,

Check out the Make.List() function. This allows you to take an array of @FM delimited data and turn it into an active select list. I use it all the time.

You can either CALL it or declare it as a subroutine.

The syntax is Make.List(0, ListVar, FileHandle, DictFileHandle)

I don't remember what the 0 (zero) represents, but that's basically a constant. ListVar is the variable with the @FM delimited data. FileHandleGreyhound Lines, Inc.[/url] </QUOTE> —- === At 22 SEP 2004 02:11PM Matt Sorrell wrote: === <QUOTE>Sorry, the text got messed up. FileHandle is the File Handle (from an OPEN statement) for the table in which the data resides. Similarly, DictFileHandle is the File Handle for the DICT portion of the data table. I have some older routines in my system where DictFileHandle was passed as a null, so I'm not sure if it is really needed. msorrel@greyhound.com Greyhound Lines, Inc. </QUOTE> —- === At 23 SEP 2004 03:02AM dsig_at_sigafoos.org wrote: === <QUOTE>make.list works under arev also I do believe Also .. the 0 is the cursor you want the list to be generated in dsig_at_sigafoos.org DSigs Radio Free Oregon Phone: 971-570-2005 </QUOTE> —- === At 23 SEP 2004 09:41AM Matt Sorrell wrote: === <QUOTE>Ahhh, so that's what the first parm is. Thanks for clearing that up!! msorrel@greyhound.com Greyhound Lines, Inc. </QUOTE> —- === At 23 SEP 2004 04:03PM Don Miller wrote: === <QUOTE>Actually MakeList uses an @VM delimited field string to make an active select list. I've never seen it used with an @FM delimited string. Don M. </QUOTE> —- === At 23 SEP 2004 04:37PM Matt Sorrell wrote: === <QUOTE>Don, Perhaps this is a difference between OI and ARev? I just checked my docs, and for ARev, they specifically state that it uses an @FM delimited string. *shrug* msorrel@greyhound.com Greyhound Lines, Inc. </QUOTE> —- === At 25 SEP 2004 02:01PM Don Miller wrote: === <QUOTE>Right. I checked my code which uses a @VM delimited list. I note that I SWAP @VM WITH @FM IN SEARCH (where SEARCH is built on the fly from a select IE .. SELECT SOMEFILE WITH DATE ] "somedate" Do a Readnext to make a @MV delimited string and the do the SWAP. Then it's an active select list. Don </QUOTE> View this thread on the forum...