Skip to main content
Nintex Community Menu Bar

SQL SmartObject Update method cannot update keys

  • November 14, 2022
  • 1 reply
  • 21 views
L

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

    L
    • ljfdlas8lkds
    • Author
    • November 30, 2022

    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.

    Sidebar Buttons
    Nintex Community Home Contact Nintex Support Email Nintex Community Check Nintex Status
    Terms & ConditionsCookie SettingsAccessibility statement