Building Select Lists one key at a time (None Specified) [Revelation On-Line Wiki]

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
{{tag>category:"None Specified" author:"Steven Bleeke, OnSight Systems, sbleeke@msn.com" author:"Donald Bakke" author:"Dsig  (SigSolutions)" author:"Jeff Blinn" author:"Steven Bleeke"}}

[[https://www.revelation.com/the-works|Join The Works program to have access to the most current content, and to be able to ask questions and get answers from Revelation staff and the Revelation community]]


==== Building Select Lists one key at a time (None Specified) ====
=== At 02 JUN 1998 11:42:50PM Steven Bleeke, OnSight Systems, sbleeke@msn.com wrote: ===
 
 
<QUOTE>
When I used to program in RevG (yes I'm old), I would add keys to saved select lists on the fly by opening the Lists file to a filvar just like any other file and reading a record,listname and concatenating a key to the end of the list with a @vm.  This worked beautiful and in the days of an 8 megahertz server it avoided alot of search and select time.



I would still like to use this technique in Open Insight but the SysLists file does not seem to be available to normal file I/O in RBasic code.  Please understand I know how to pull up the list and type a value at the end what I want to do is something like I used to do above.



Thanks, Steve
</QUOTE>
----

=== At 03 JUN 1998 01:47AM Donald Bakke wrote:  ===

<QUOTE>Steve,



We have no problems working with the SYSLISTS table that way. By the way, did you mean @FM instead of @VM when describing your process?



dbakke@srpcs.com

[url=http://www.srpcs.com]SRP Computer Solutions[/url]

[img]http://www.srpcs.com/srpicon1.gif[/img]

</QUOTE>

----

=== At 03 JUN 1998 11:16AM Dsig  (SigSolutions) wrote:  ===

<QUOTE>Steve,



It seems to work here .. in fact just tried it with 3.6.1 and all is find (whew ..)





dsig

David Tod Sigafoos ~ SigSOlutions

dsig@teleport.com  cis:70302,77  voice:503-639-8080

</QUOTE>

----

=== At 03 JUN 1998 01:49PM Jeff Blinn wrote:  ===

<QUOTE>In the following code, the first open works fine, the second fails. Check the upper/lower case of the filenames.



--------------------------



Subroutine TestOpen(void)

Declare Subroutine Msg

Open 'SYSLISTS' to test1 else

  Msg(@window,'Could not open SYSLISTS')

end

Open 'SysLists' to test2 else

  Msg(@window,'Could not open SysLists')

end

Return

</QUOTE>

----

=== At 11 JUN 1998 08:06PM Steven Bleeke wrote:  ===

<QUOTE>Glad to know this works in OI.  I will keep working at it.

</QUOTE>


[[https://www.revelation.com/revweb/oecgi4p.php/O4W_HANDOFF?DESTN=O4W_RUN_FORM&INQID=WORKS_READ&SUMMARY=1&KEY=164F2405DE15AFAB85256618001466BE|View this thread on the Works forum...]]