jbpelletier
Programmer
I have a little problem editing TQuery SQL property.
For Exemple if i whant to list all record from MyTable Where MyField is empty this work in Access (My Database is an Access one) but dont return any record if i use it in Delphi with the TQuery.SQL (active is true)
SELECT *
FROM MyTable T
WHERE T.MyField = NULL
i have also tryied '' and "" instea of NULL because MyField is a string, but still return no record.
any idea why it dont list any result..
by the way it give me the good result if i do :
SELECT *
FROM MyTable T
WHERE T.MyField <> NULL
For Exemple if i whant to list all record from MyTable Where MyField is empty this work in Access (My Database is an Access one) but dont return any record if i use it in Delphi with the TQuery.SQL (active is true)
SELECT *
FROM MyTable T
WHERE T.MyField = NULL
i have also tryied '' and "" instea of NULL because MyField is a string, but still return no record.
any idea why it dont list any result..
by the way it give me the good result if i do :
SELECT *
FROM MyTable T
WHERE T.MyField <> NULL
