Re: Query Date Column from FORMS 4.5

in ur pre-query u can code some thing like this

[Quoted] trunc(date_column) = trunc(:whatever_entered_in_form) this will eliminate the time
component from the date , u can add this to the where clause of the block by

set_block_Property('BLOCK', DEFAULT_WHERE, where_condition);

Hope this helps

• Arvind

Ed Jennings wrote:

> I'm writing a FORMS 4.5 app on NT 4.0. I want to allow users to enter a
> date (DD_MON_YY) in the form to qualify the query. However, the query
> never finds any rows, even though I know it exists. I'm certain I'm
> getting burned by the lack of time in the mask, but I don't know how to
> get around it. If I specify a PRE_QUERY trigger with > date_column, it
> works fine. But I want to be able to isolate a specific date, not just
> greater than. Any suggestions???
>
> TIA
> Ed
> --
> ~~~~~~~~~~~~~~~~~~~~~~~~~
> jenningse_at_mindspring.com
>
> "The opinions expressed here are my own, not those of DOMAIN
> technologies"

--
Balaraman Arvind
151 Andrew Ave, Apt 215
Naugatuck, CT 06770

ph   -  (203)-723-1190(R)
     -  (203)-459-7502(O)

mail -  dnivra_at_ix.netcom.com (R)
        abalaram_at_oxhp.com    (O)