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:

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 [email protected] 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].

[email protected]

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 [email protected] - [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.

[email protected]

Sprezzatura, Inc.

www.sprezzatura.com_zz.jpg

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 [email protected] - [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.

[email protected]

Sprezzatura, Inc.

www.sprezzatura.com_zz.jpg

View this thread on the forum...