SQL SmartObject Update method cannot update keys | Community

I have a SQL table with composite primary key fields A, B, and C.

The default update method produced cannot update the any of the 3 primary key fields.

Can I set up the SmartObject Update method to be able to update the primary key fields? Can I do this without setting up an Identity primary key and changing A,B, and C to a unique constraint?

Page 1 / 1

we couldn't find a way to update a SQL table with composite key, so we redesigned the table to have an autonumber identity primary key.

Reply