Re: include current date in logical file

I don't think he is creating an index, he is using DDS to create a regular logical file - nothing said about key fields.

Now having said that, I think he could do what he wants with a VIEW - the WHERE clause could have something like

WHERE OHORDT = CURRENT DATE

This does work in 7.1, just tried it.

It makes sense that we can't use special registers - how do you continually maintain an index where this value changes all the time - in fact, UDFs are out of the picture.

Now a view maintains nothing - the SELECT is run each time the view is used. Therefore, no problem with values that change often.

HTH
Vern

----- Original Message -----
Acording to the SQL manual, the "WHERE" expression in the "CREATE INDEX"
can not contain special registers (like current_date)

Booth Martin wrote:

What sort of a field is OHORDT? Is it a 6 or 8 digit, alpha or numeric
field or a true date field?

On 5/20/2013 4:47 PM, Crystal Reports wrote:

I want to create a logical file which would only
include dates current

this does not compile:

I OHORDT COMP(EQ UDATE)