Subject Re: SQL WHERE Clause Not Working Since Upgrade to Plus 11
From Ken Mayer <dbase@nospam.goldenstag.net>
Date Mon, 18 Sep 2017 22:15:40 -0700
Newsgroups dbase.getting-started

On 9/18/2017 8:23 PM, Bryce Westover wrote:
> My SQL statement that has worked for years in Plus 9 is failing in Plus 11:
> sql = 'select * from :Films101:Films101 WHERE Country = " "'
>
> It works as expected without the WHERE clause, but not with.

When you say "failing" is it returning an error? If so, what is the error?

Have you tried:

WHERE Country is null

??

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