Re: Querying Forms5
Date: Fri, 6 Oct 2000 08:57:44 -0600
Message-ID: <9RlD5.35$jo1.9188_at_wdc-read-01.qwest.net>
The & is used to get to the general query dialog, where you can use & again to represent the name of the field in which you entered the first ampersand. Handy for users who do not know the column names.
<sybrandb_at_my-deja.com> wrote in message news:8rkcrg$m7$1_at_nnrp1.deja.com...
> 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
> >
> >
> 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.
Received on Fri Oct 06 2000 - 16:57:44 CEST