Subject Re: And not Null
From Ken Mayer <dbase@nospam.goldenstag.net>
Date Tue, 29 Jan 2019 21:22:00 -0800
Newsgroups dbase.getting-started

On 1/29/2019 9:02 PM, Mervyn Bick wrote:
> On 2019-01-30 6:55 AM, Mervyn Bick wrote:
>
>> In  the SQL statement for a query in OODML one needs to use is instead
>> of = when comparing a field value.
>>
>> e.g  sql = ' ... where something >= 0 and whatever is not null'
>
> Still running on the first cup of coffee. :-)
>
> That should have read when "comparing a field value for null.".  When
> testing for actual values = and the other comparison operators work as
> expected.

Ugh. I knew I missed something in there. I don't use it often (and I'm
doing lots of SQL these days).

Ken


--
*Ken Mayer*
Ken's dBASE Page: http://www.goldenstag.net/dbase
The dUFLP: http://www.goldenstag.net/dbase/index.htm#duflp
dBASE Books: http://www.goldenstag.net/dbase/Books/dBASEBooks.htm
dBASE Tutorial: http://www.goldenstag.net/dbase/Tutorial/00_Preface.htm