Re: (no subject)
Date: Fri, 06 Oct 2000 20:19:16 GMT
Message-ID: <39DE31D9.822AB83F_at_home.nl>
Can't quite remeber otomh what the & did, but I think
the final statement to the server would be:
where ....
and date_field = IS NULL;
or:
where ....
and IS NULL;
You know what's wrong with that...
Guess you need to fill in:
date_field is null (and hope for the second scenario!)
BTW, when the error occurs, hit shft-F1 to see the statement
kskasi_at_hotmail.com wrote:
> 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 - 22:19:16 CEST