Re: (no subject)

From: Andrew Hardy <Andrew.Hardy_at_BGTechnology.com>
Date: Fri, 6 Oct 2000 08:42:08 +0100
Message-ID: <8rjvod$8ne$1@sun-cc204.lboro.ac.uk>

Forms ignores blank columns during the query - after all you'd probably not find any records that match your query if most of the fields are blank.

You need to manipulate the default_where property of the block at query time to include your 'x IS NULL' statement. You will probably need a 'flag' for the user to select to show that the query is to use the null or blank interpretation of the column.

Andy
<kskasi_at_hotmail.com> wrote in message news:39DD7BF2.D72562D7_at_hotmail.com...
> Hello everyone
>
> I was wondering if its possible to search on null columns in forms5.
>
> Eg: I have a date field and I would like to bring all the records that
> has no dates. I tried executing using & and I entered IS NULL in the
> dialog box that came up. But it showed an Oracle error. Also I would
> like to serach all the records that are between 2 dates.
>
> Is it possible to do such things in Forms. Any help would be appreciated
>
> Thanx ...Kasi
>
>
>
Received on Fri Oct 06 2000 - 02:42:08 CDT