Frank Rocco
|
Posted: 07/05/2001, 10:31 AM |
|
Hello,
I have a date_in field that is not updated when I create a new record.
I want to limit the grid to show records where this field has not been
changed.
I have tried several times to get this to work.
What is the correct syntax for selecting records with no date entry.
I tried date_in = Null
date_in = 0
Thanks
Frank
|
|
|
Alexey Alexapolsky
|
Posted: 07/05/2001, 11:46 AM |
|
try
date_in IS NULL
--
CC Alex
Frank Rocco <farocco@hotmail.com> wrote in message
news:9i2893$7lc$1@news.codecharge.com...
> Hello,
>
> I have a date_in field that is not updated when I create a new record.
> I want to limit the grid to show records where this field has not been
> changed.
>
> I have tried several times to get this to work.
> What is the correct syntax for selecting records with no date entry.
> I tried date_in = Null
> date_in = 0
>
> Thanks
> Frank
>
>
|
|
|
Frank Rocco
|
Posted: 07/05/2001, 11:56 AM |
|
Thanks Alex, that did the trick.
Regards,
Frank
"Alexey Alexapolsky" <alexa@codecharge.com> wrote in message
news:9i2cma$gbf$1@news.codecharge.com...
> try
>
> date_in IS NULL
>
> --
> CC Alex
>
>
> Frank Rocco <farocco@hotmail.com> wrote in message
>news:9i2893$7lc$1@news.codecharge.com...
> > Hello,
> >
> > I have a date_in field that is not updated when I create a new record.
> > I want to limit the grid to show records where this field has not been
> > changed.
> >
> > I have tried several times to get this to work.
> > What is the correct syntax for selecting records with no date entry.
> > I tried date_in = Null
> > date_in = 0
> >
> > Thanks
> > Frank
> >
> >
>
>
|
|
|
|