Skip to main content
Nintex Community Menu Bar

Another K2 five cadet question sorry! I have noticed that when I create SMO from a SQL broker the fields that are required in SQL are also required in the SMO, this is also on "Is Identity - Yes" fields in SQL.  In 4.7 this was not the case as the ID fields are generated by SQL as autoincrement and passed back tot he SMO. I think I may have confiured the broker incorrectly but at the moment I'm having to edit the SMO after creation in designer and uncheck the required box for the ID fields. Other wise I cannot run any create methods at all! Has anyone else experienced this?

I don't have any problem with it. This is the SQL table which I tested on:


 


CREATE TABLE Test (


  id int not null identity(1,1) primary key,


  someValue nvarchar(50) not null


)


 


When I create SMO from the Service Object Tester, then execute the SMO Create method, it only prompt me to enter someValue, and I do not need to specify the id.


Hi There, In an effort to embrace the new approach I'm not using SOTT so perhaps that is why the SMO generation experience is different? or I've not configured the broker correctly


Reply