MSSQL Server "Field 'ID' cannot be modified

[Drewsky]

Hi,

I am using TUniTable, Delphi 10.4 and MSSqlServer database. I am using DBTreeView and when I try to insert a new record (tree node) I get an error "Field 'ID' cannot be modified. If I set TUniTable.Options SetFieldsReadOnly to FALSE and the MSSQL Server does not accept the record. This works normally with MySQL database, which is identical in structure. Also the MSSQL server database works fine in all other aspects. Only the DBTreeView (I have tried multiple versions) is the problem.

Kind regards

[zorino]

Hey,
same problem here... (without any DBTreeView)

Did u solve yours ?

[pavelpd]

Hi,
We were unable to reproduce the "Field 'ID' cannot be modified" error you mentioned.
Please create an example application that reproduces the indicated error, with all the necessary DDL and DML scripts to create and populate the database, and send it to us via the e-support form: https://www.devart.com/company/contactform.html