J
jonas_ja_
Guest
I have a Progress database with lots of fields one of which is a boolean field. I am using the delphi language to get the data from the database through a dbgrid component. But this is really confusing, sometimes on the dbgrid I get the boolean field as false and sometimes as true. The expected value is true, but this error it seems like it's ramdom.
Connect:= TSQLDataSet.Create(Self);
Connect.SQLConnection := mdPpal.prgContab;
Connect.CommandText := 'SELECT cod, name, result FROM PUB.maesaldo WHERE cod_ejerc= 20 AND cod_comp = 1 AND close IS NULL ORDER BY cod';
Connect.Open;
Connect.FieldValues['result']) //this value it's supposed to be false, but sometimes it is true, 1 out of 10.
Continue reading...
Connect:= TSQLDataSet.Create(Self);
Connect.SQLConnection := mdPpal.prgContab;
Connect.CommandText := 'SELECT cod, name, result FROM PUB.maesaldo WHERE cod_ejerc= 20 AND cod_comp = 1 AND close IS NULL ORDER BY cod';
Connect.Open;
Connect.FieldValues['result']) //this value it's supposed to be false, but sometimes it is true, 1 out of 10.
Continue reading...