Page 1 of 1

MSSQL Server "Field 'ID' cannot be modified

Posted: Wed 22 Dec 2021 11:26
by 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

Re: MSSQL Server "Field 'ID' cannot be modified

Posted: Fri 18 Feb 2022 14:12
by zorino
Hey,
same problem here... (without any DBTreeView)

Did u solve yours ?

Re: MSSQL Server "Field 'ID' cannot be modified

Posted: Fri 25 Feb 2022 08:03
by 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