[stackoverflow] [progress Openedge Abl] Delphi Dataset Value Keeps Changing

[Jon]

I have delphi form which has a TDBgrid, TDataSource, TClienDataSet, TDataSetProvider, TSQLDataSet. The TSQLDataSet make the query to the Progress database. The query is something like this SELECT codaccount, name, result FROM PUB.account WHERE cod_ejer = 19 AND cod_ent = 1 AND acc_closed IS NULL ORDER BY codaccount. This is supposed to like about 900 rows. The column named result is a boolean data type that in some rows is true and others is false, but when i run the application sometimes I get the expected value for the result column which is true or false. Then I open the form again and all rows have true as the value for the result column. I close the form and open it again and it goes back to normal true or false. I close it again and is all true. It is a random thing sometimes it happens, sometimes it doesn´t happen at all. I tried everything but I can´t find the solution.

Continue reading...