Re: Query Date Column from FORMS 4.5

One suggestion is to change your PRE-QUERY to be

# >=date_column AND <= date_column+0.99999

Adding 5 9's to a date with zero time component makes it 23:59:59 and so the range will now match any databases rows nomatter what their time components are set up.

There may be a better way (someelse will no doubt advise if there is!)

Ian

On Sat, 28 Feb 1998 16:48:46 -0500, Ed Jennings [Quoted] <jenningse_at_mindspring.com> 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"
>
Received on Sun Mar 01 1998 - 00:00:00 CET