🚀 go-pugleaf

On Mon, 02 Mar 1998 17:26:49 +0800, Wilson Woo <wilson00@hk.super.net>
wrote:

>I'm using Delphi TTable & TQuery components to select table records.
>The table is used to store staff information.
>There is a field named 'ACTIVE', which is Boolean type, to reveal that
>the staff is working or resigned ('ACTIVE' = True for working).
>
>My question is how to use SQL to select all staff that is working
>('ACTIVE' = True)?
>
>I have tried:
>
>  select * from STAFF where 'ACTIVE' = True
>
>but no record returned.
>
>The table, STAFF.DBF, is a Fox Pro database.

Could be that putting that column name in quotes is throwing it off. Try
prefixing it with the table name or a table correlation name. This way, the
SQL parser will be sure that you are trying to compare a column, and not a
string, to True.

  SELECT *
  FROM "STAFF.DBF" S
  WHERE (S."ACTIVE" = True)

In local SQL, a boolean literals are True and False, and may be expressed
with or without quotation marks.

  SELECT *
  FROM "STAFF.DBF" S
  WHERE (S."ACTIVE" = True) OR (S."ACTIVE" = "False")

**************************************************************************
Steve Koterski
Borland International, Inc.
http://www.borland.com/delphi
(Remove the "SPICEDHAM2" from the address. Death to spam-bots!)