I have upgraded to UniDAC 8.0.1 from version 7.4.12 and experienced that when I open a temporary table in PostgreSQL using an UniQuery, the UniQuery is read only and I get an exception, if I want to e.g. insert a new record.
The error occured consistently in PostgreSQL 11 as well as in PostgreSQL 12.
Example to reproduce the issue:
Code: Select all
UniConnection1.ExecSQL('create temp table mytemp(a int8 primary key, d json)');
UniQuery1.sql.text := 'select * from mytemp';
UniQuery1.active := true;
UniQuery.insert; <<<====== This gives an exception that the dataset is read only
Code: Select all
UniConnection1.ExecSQL('create table mytemp(a int8 primary key, d json)');
UniQuery1.sql.text := 'select * from mytemp';
UniQuery1.active := true;
UniQuery.insert; <<<====== Now everything works without error !!!!
I suspect the following bug fix to be responsible for this behaviour:
Version 7.5.13 (24-Jun-19): Bug with attempting to save data to read-only fields when modifying a dataset is fixed
Please provide me with a short feedback on this issue!