I am currently having problems with the Arev select statement not returning records.If I enter the following select statements individually, records are generated as one would expect:

 1. select invoice ( with date from "07-01-00 to 07-27-00" )

 2. select invoice ( with gl_post_date=' )

But, when I combine the statements as follows:

select invoice ( with gl_post_date=' ) and ( with date from "07-01-00 to 07-27-00" )

no records are produced. I have rebuilt both indexed fields to no avail.

Now, if I use SQL and use the following SQL statement, all the records are produced.

select date, gl_post_date

from invoice

where date between "07-01-00" and "07-27-00"

and gl_post_date is null

Can someone please give me a clue as to what is going on?

Any help you can provide will be greatly appreciated!!!

Thank You,

Jorgeanna Clifton

Which version of ARev?

From TCL type "WHO"

Jorgeanna

You tried :

select invoice ( with gl_post_date=' ) and ( with date from "07-01-00 to 07-27-00" )

Try this:

select invoices with date from "07-01-00" to "07-27-00" and with gl_post_date='

The order in which you resolve the selection is important.

I find doing the selections one at a time easier/faster

than doing the entier selection in one command. I would

create a voc command to simplify the process. Example:

EDIT VOC TEST

TCL

* This command does ——-

SELECT INVOICES WITH DATE FROM ?"Start Date"? to ?"End Date?".

SELECT INVOICES WITH GL_POST_DATE='

Hope this helped.

I am not sure about this…

since both fields are indexed, I would assume that the proper way to use the select would be to do it with two statements.

In my time as a programmer, I somehow remember problems with selecting more than one indexed field within a single select. I have always used the "one at a time" technique when dealing with indexed fields.

Does AREV have a bug??? I dont know. And, if the two step method works… then that is what I would use.

Firstly, if you are pre AREV 3.12 you need to state the version, woing to differences in the select logic in AREV 3.0x and 3.10.

Secondly, you should check the dictionary to ensure that the input and output conversions on your date fields are present and the date fields are right-justified, and that the data internally in these fields is purely numeric.

Thirdly, if the date field(s) are indexed, try removing the indexes, then running your select.

Fourthly, always run the date conparisons with ]= and = "05 JUL 1999" AND WITH INVOICE.DATE =< "8 JUL 1999"

The BETWEEN syntax was not reliable on early versions of AREV, and was missing on some others.

[email protected]

View this thread on the forum...