I have finished application (Builder C++) useing BDE and Paradox table. After all I wanted to change engine to other. It is MySQL + ODBC. Now there is no more suport for SQL statements like:
"select * from TableName"
"where record_saved = true"
record_saved is ftBoolean type. MySQL returns error:
>> true - invalid column name<<.
ftBoolean is converted to TINYINT(1).
How can I overcome this, and make my app to work with no big changes. Is there an interface I can modyfy 'true -> 0' ?