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?
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.