To simplify things and help our users to be more productive, we have archived the current forum and focus our efforts on helping developers on Stack Overflow. You can post new questions on Stack Overflow or join our Discord channel.
I've an issue with a MS SQL table compared to a HYPERSQL one!
The MS SQL table holds a primary key like:
PK_ID INT IDENTITY(1,1),
The HYPERSQL table defines the primary key as:
PK_ID IDENTITY PRIMARY KEY,
So both are defined as AUTO_INCREMENT fields!
But the rowItem.getItemProperty("PK_ID").setValue(....) can only be set in the HYPERSQL version and NOT in the MSSQL one. The latter yields a readonly error! In fact in the HYPERSQL case the SQLContainer has the allowReadOnlyChange set to true for its PK_ID ColumnProperty while the MS SQL version has the allowReadOnlyChange set to false!
Any idea how to solve this issue for MSSQL database?