Re: Querying Forms5

[Quoted] In article <39DD7C3D.5B1842A6_at_hotmail.com>,   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
>
>

[Quoted] IIRC the & is a placeholder, and you still need to include a column name. If that doesn't work, my question is *which* error?

Hth,

--
Sybrand Bakker, Oracle DBA

All standard disclaimers apply
------------------------------------------------------------------------


Sent via Deja.com http://www.deja.com/
Before you buy.