Re: (no subject)

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 - 15:19:16 CDT