Re: include current date in logical file

[Vern Hamberg <vhamberg@xxxxxxxxxxxxxxx>]

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)
> >
> >    
>
>