Programming with dBASE - Re: select null logical fields

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Re: select null logical fields

Cliff Rielly

2006-04-02, 9:23 am

Hi Roland

Very many thanks. There is no way I would have worked out it needed 'is'!

Regards

Cliff

"Roland Wingerter" <ich@hier.de> wrote in message
news:%235SvL$iVGHA.556@trueshotDaddy.secureserver.net...
> Cliff Rielly wrote
> -------
> Try this:
>
> sql = ;
> "select * from conthist.dbf ;
> where closeflag = true ;
> and (Accflag = false or Accflag is null)"
>
> Roland
>

Sponsored Links