SQLIte DAC: Error value in Boolean field
Posted: Wed 13 Feb 2013 10:41
I download "LiteDAC Demo" and open database "TestBoolean.db3":
Table "Test" has two records:
In first "Value" must be "True"
In second "Value" must be "False"
After execute query "SELECT * FROM Test" I see that both record have "Value=False"
This error is also in the "UniDAC"
Small sample I send to AlexP devart.com
Code: Select all
BEGIN TRANSACTION;
CREATE TABLE Test (Value Boolean, Name VarChar(20));
INSERT INTO Test VALUES('t','True value');
INSERT INTO Test VALUES('f','False value');
COMMIT;
In first "Value" must be "True"
In second "Value" must be "False"
After execute query "SELECT * FROM Test" I see that both record have "Value=False"
This error is also in the "UniDAC"
Small sample I send to AlexP devart.com