[[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]]
==== Select list from data (OpenInsight 32-bit Specific) ====
=== At 22 SEP 2004 01:26:24PM Jared Lessl wrote: ===
{{tag>"OpenInsight 32-bit Specific"}}
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.
----
=== At 22 SEP 2004 01:27PM Jared Lessl wrote: ===
Sorry, put this in the wrong discussion group. Should be under AREV.
----
=== At 22 SEP 2004 02:08PM Matt Sorrell wrote: ===
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. [b]ListVar[/b] is the variable with the @FM delimited data. [b]FileHandleGreyhound Lines, Inc.[/url]
----
=== At 22 SEP 2004 02:11PM Matt Sorrell wrote: ===
Sorry, the text got messed up.
[b]FileHandle[/b] is the File Handle (from an OPEN statement) for the table in which the data resides. Similarly, [b]DictFileHandle[/b] 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
[url=http://www.greyhound.com]Greyhound Lines, Inc.[/url]
----
=== At 23 SEP 2004 03:02AM dsig_at_sigafoos.org wrote: ===
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
[url=http://www.sigafoos.org/samweb]DSigs Radio Free Oregon[/url]
Phone: 971-570-2005
----
=== At 23 SEP 2004 09:41AM Matt Sorrell wrote: ===
Ahhh, so that's what the first parm is.
Thanks for clearing that up!!
msorrel@greyhound.com
[url=http://www.greyhound.com]Greyhound Lines, Inc.[/url]
----
=== At 23 SEP 2004 04:03PM Don Miller wrote: ===
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.
----
=== At 23 SEP 2004 04:37PM Matt Sorrell wrote: ===
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
[url=http://www.greyhound.com]Greyhound Lines, Inc.[/url]
----
=== At 25 SEP 2004 02:01PM Don Miller wrote: ===
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
[[https://www.revelation.com/revweb/oecgi4p.php/O4W_HANDOFF?DESTN=O4W_RUN_FORM&INQID=NONWORKS_READ&SUMMARY=1&KEY=9A7905E8147681C885256F17005FCD5F|View this thread on the forum...]]