Skip to main content
Nintex Community Menu Bar

Writing to an Azure SQL DB

  • April 7, 2017
  • 2 replies
  • 18 views

Forum|alt.badge.img+3

I'm beginning to experiment with SQL service instances.  I've figured out how to read/list data from a SQL DB, but I'm wondering if there's a way to write data back to a database.  I experimented with creating a "create" method for the smartobject associated with the table... but no luck.

2 replies

Forum|alt.badge.img+3
  • Author
  • April 7, 2017

Nevermind... I forgot to create a primary key on the table.  Only the "list" object is created if there's no PK.


Forum|alt.badge.img+6
  • Nintex Partner
  • May 2, 2017

In k2 - If you dont have PK in the table you will not get create,update and delete method . so to overcome from the problem please design primary key in the table and recreate SMO.