🚀 go-pugleaf

On Thu, 11 Feb 1999 13:28:22 -0500, "Bert Vergeer"
<av-base.sys@sympatico.ca> wrote:

>Sorry for not being specific enough.  I have been working in both the
>ISQL(part of SQL Server) and this statement below works, but using this in
>Vdbase, this doesn't work.  I am building my SQL statement in the SQL
>property of the query object.  My SQL statement goes like this:
>
>select * from "...\specserve.dbf" where compldate = Null
>
>except I am getting an error in the where clause.

In standard SQL, one uses the IS NULL predicate to check a column against a
NULL value. Try this variation:

  SELECT *
  FROM "...\specserve.dbf"
  WHERE compldate IS NULL

The IS NULL predicate can also be used with the NOT operator.

  SELECT *
  FROM "...\specserve.dbf"
  WHERE compldate IS NOT NULL

//////////////////////////////////////////////////////////////////////////
Steve Koterski                       "For people who like peace and quiet:
Technical Publications               a phoneless cord."
INPRISE Corporation                                             -- Unknown
http://www.inprise.com/delphi