Re: select statment with between date parameters

I agree with Mike: why not use WHERE clause ? Anyway the first time I tried in Forms 5.0 a syntax error occurred. Using three qoutes solved the problem. The generic statement is:

select field1, field2 from tablename where datefield BETWEEN ''' || :DATE_BLOCK.START || ''' AND ''' || :DATE_BLOCK.END || ''' ORDER BY datefield;

Mike Morgan wrote:

> select MAX(datefield) from tablename;
> select MIN(datefield) from tablename;
>
> (why can't you use a WHERE clause?)
>
> Chistine Do wrote in message ...
> >Hello All,
> >I would like to know how to create a select statement using the greatest
> and
> >least to select the date parameters (ex. 05-aug-98 to 05-apr-99) without
> >using the where clause.
> >
> >Please advice!
> >
> >Thanks
> >Christine
> >email: christine_at_idec.com
> >
> >

Received on Sat May 22 1999 - 14:35:21 CDT