Re: Query Range of Dates in Forms
Date: 1 Sep 1998 05:23:13 GMT
Message-ID: <1998090105231300.BAA25775_at_ladder03.news.aol.com>
>I have a date field in a FORM. Sometimes the user wants
>to query a range of dates, as opposed to a particular date.
>How can this be done. The users have no knowledge of SQL, and
>couldn't construct an 'AND' clause if their life depended on it.
>What they would like to enter is something like:
>
> 15-AUG-98..18-AUG-98
>
>The FORM needs to be smart enough to recognize a single date or
>a range of dates. Anyone know how this can be done without
>introducing a second date field?
>
>TIA
>
>Ed Jennings
>
>
>--
>~~~~~~~~~~~~~~~~~~~~~~~~~
>jenningse_at_mindspring.com
>
>
If you are forced to create a second field, you can make it only show up during
query mode. To do this, in the when-new-record-instance, put a check for
:SYSTEM.MODE = 'QUERY' (double check that...) If it is true, then show and
enable the field, else hide it. In the pre-query trigger, check it and make the
appropriate condition.
Dan Hekimian-Williams Received on Tue Sep 01 1998 - 07:23:13 CEST