Skip to main content
Nintex Community Menu Bar

K2 Five create SmartObject on Table with one Field is identify and other is Primary Key

  • December 20, 2018
  • 1 reply
  • 11 views
F

Hello at all,

 

i have to start in SQL. My Tables are created like that way:

16138i703071AC549D1BC2.png

 

 

The Problem is, that i can't change from Required Yes to Required No on the Primary Key field Z_ID.

K2 misinterprets my logic of the SQL Table. Is there any chance or idea to get this being correct on Required = No?

 

Many thanks in advance!

Best greetings

Fabian

    1 reply

    F
    • FabianD
    • Author
    • December 20, 2018

    For all with the same problem.

    Workaround for now is a Procedure which creates a new entry in the database. So an extra itemview which just creates new entries with the smartObject based on the procedure and another Listview where you can list, update, delete the entries. 

    Here to find. https://www.codeproject.com/Articles/417084/Auto-incremented-ID-with-NVARCHAR-VARCHAR-datatype

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