Skip to main content
Nintex Community Menu Bar

SQL SmartObject Update method cannot update keys

  • Nov 14, 2022 5:26 PM UTC
  • 1 reply
  • 45 views
  • Translate All

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

    • ljfdlas8lkds
    • Author
    • Rookie
    • Nov 30, 2022 5:39 PM UTC

    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.

    Translate
    Sidebar Buttons
    Nintex Community Home Contact Nintex Support Email Nintex Community Check Nintex Status
    Terms & ConditionsAccessibility statement