🚀 go-pugleaf

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.

Thank you for kind attention.
Please reply by email as well.

Wilson.