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


==== RLIST - Select and Loop.. Readnext (OpenInsight Specific) ====
=== At 02 FEB 1999 05:18:42PM b. cameron wrote: ===
 
{{tag>"OpenInsight Specific"}}
 
<QUOTE>
Can someone help with this ....



  cmd=Select File if date GE "':D1:'" and LE "':D2:'" '

  statuscode=Set_Status(0)

  SCmd=Cmd

  Call RLIST(SCmd,"5","","","")

  If Get_Status(statuscode) Then

      xmsg=statuscode

      Gosub ErrMsg

      Goto EndOfJob

  End

*

   Loop

      Readnext @ID else NoMore=1

   Until NoMore do

      Read ...

   Repeat

*



My items returned from the Rlist command are far greater than they

should be.  Should I not use a target of 5?  Should I get the save

list and then process?
</QUOTE>
----

=== At 03 FEB 1999 04:07AM amcauley@sprezzatura.com onmouseover=window.status=why not click here to send me email?;return(true)", [url=http://www.sprezzatura.com" onMouseOver=window.status=Why not click here to visit our web site?';return(true)]Sprezzatura Ltd[/url] wrote:  ===

<QUOTE>Two things - BETWEEN is better than GE and LE - [i]much[/i] quicker if the field is indexed. Strictly the GE LE syntax requires [b]with date GE X and with date LE Y[b].



amcauley@sprezzatura.com 

[url=http://www.sprezzatura.com" ]Sprezzatura Ltd[/url]

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

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





</QUOTE>

----

=== At 03 FEB 1999 10:59AM b cameron wrote:  ===

<QUOTE>Andrew, thanks for the response.



I tried SELECT the file WITH DATE GE "XX/XX/XXXX" AND WITH DATE LE "XX/XX/XXXX"   and still got more results than were correct.



In another utility I have if I LIST the file WITH DATE GE "XX/XX/XXXX" AND WITH DATE LE "XX/XX/XXXX" I get the

correct items returned.



I am still confused...

</QUOTE>

----

=== At 04 FEB 1999 09:02AM akaplan@sprezzatura.com - [url=http://www.sprezzatura.com]Sprezzatura, Inc.[/url] wrote:  ===

<QUOTE>So am I.  LIST runs through the same process as SELECT to retrieve data, so unless you're changing dates or somehow have an active list there, the results should be identical.



Do me a favor.  Change the statement to GT date-1 and LT date+1.  Effectively it's the same results, but I'm testing a probably incorrect theory.



Also, try it both ways but add the CASEINSENS modifier before the field name.







akaplan@sprezzatura.com

[url=http://www.sprezzatura.com]Sprezzatura, Inc.[/url]

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



</QUOTE>

----

=== At 04 FEB 1999 11:34AM bmc wrote:  ===

<QUOTE>Aaron,



I actually changed it to WITH DATE1 BETWEEN "XX/XX/XXXX" AND "XX/XX/XXXX" and it worked but am still puzzled as to why the  other way did not.



Thanks for the respose.



bruce

</QUOTE>

----

=== At 05 FEB 1999 08:40AM Nick Stevenson wrote:  ===

<QUOTE>And the second thing?



There are three types of accountant - first, the ones who can add, and second, those that can't.

</QUOTE>

----

=== At 05 FEB 1999 09:10AM akaplan@sprezzatura.com - [url=http://www.sprezzatura.com]Sprezzatura, Inc.[/url] wrote:  ===

<QUOTE>It's kinda hard to explain, but basically it's the effects of GENRTP20_SUB and $RTP21 and how every modifier has a very special meaning.





akaplan@sprezzatura.com

[url=http://www.sprezzatura.com]Sprezzatura, Inc.[/url]

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

</QUOTE>


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