MSSQL Server "Field 'ID' cannot be modified
Posted: Wed 22 Dec 2021 11:26
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
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