[[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]]


==== database 'selects' - newbie 14  (OpenInsight 32-bit Specific) ====
=== At 26 APR 2010 02:19:33PM ronald brown wrote: ===
 
{{tag>"OpenInsight 32-bit Specific"}}
 
<QUOTE>
Hi All,

newbie question # 1

I'm a newbie to OI. Just purchased OI 9.1 and have some questions that I generated going thru documentation, the website and just trying some things.

I will post each as a new topic, so that they can be treated individually.

TIA for helping with your ideas, suggestions and comments.



Running OI 9.1, on a win xp client. The server is a windows 2000 server box, running Unidata, and an application called Manage 2000.



In my current environment, I can build select statements in a basic program, such as the following, execute them, then use readnext to process the final result...

stmt=SSELECT CM WITH City=Buffalo" AND Amt_Due ] "10000" BY Last_Name'. The result is a sorted list that I iterate thur using READNEXT.



In the BASIC+ documentation, I see 'select' and 'select by', but these appear to select the entire table, which then needs to be processed thru READNEXT.



Is there a way to select the data from a program, then only process the much shorter list as the result?



thanx,

ron
</QUOTE>
----

=== At 26 APR 2010 03:06PM DSig (SigSolutions) wrote:  ===

<QUOTE>We don't "execute" but we have RLIST().  Look in the programmers reference for RLIST.  You can create a select list, create active list etc with it ... passing a string like you note

</QUOTE>

----

=== At 26 APR 2010 04:41PM ronald brown wrote:  ===

<QUOTE>Thanx again for your help.



I thought, from the very old days of Revelation G, that RLIST was solely for producing a report. I'll have to bring myself up to date on that command.

thanx,

ron

</QUOTE>

----

=== At 04 MAY 2010 03:58AM John Godfrey wrote:  ===

<QUOTE>e.g. Job=SELECT LOADS WITH DATE ]= ":QUOTE(From):" AND WITH DATE <= ":QUOTE(To):' '



Rlist(Job,5,'','','')



Hope this helps

</QUOTE>

----

=== At 04 MAY 2010 09:25AM  [url=http://www.sprezzatura.com]The Sprezzatura Group[/url] wrote:  ===

<QUOTE>Sorry for the pedantry but thus is a classic performance mistake when using indexes. Use BETWEEN otherwise the system will select all those dates ]= then all those dates The Sprezzatura Group[/url]

[url=http://www.sprezzatura.com/blog]The Sprezzatura Blog[/url]

[i]World leaders in all things RevSoft[/i]

[img]http://www.sprezzatura.com/zz.gif[/img]

</QUOTE>

----

=== At 04 MAY 2010 02:22PM ronald brown wrote:  ===

<QUOTE>Thanx for your suggestions and the 'hint' concerning 'BETWEEN'.



I have been playing with the syntax, and some of it is coming back from the 'old days' of Rev G.



ron

</QUOTE>


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