RLIST - Select and Loop.. Readnext (OpenInsight Specific) [Revelation On-Line Wiki]

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

At 02 FEB 1999 05:18:42PM b. cameron wrote:

OpenInsight Specific

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?

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:

Two things - BETWEEN is better than GE and LE - much 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

Sprezzatura Ltd

World Leaders in all things RevSoft

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

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…

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

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

Sprezzatura, Inc.

At 04 FEB 1999 11:34AM bmc wrote:

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

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

And the second thing?

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

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

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

Sprezzatura, Inc.

View this thread on the forum...