SQL SmartObject Update method cannot update keys

  • 14 November 2022
  • 1 reply

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?

1 reply

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.