Skip to main content
Nintex Community Menu Bar

Writing to an Azure SQL DB

  • Apr 7, 2017 12:25 PM UTC
  • 2 replies
  • 27 views
  • Translate All

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
  • Apr 7, 2017 6:55 PM UTC

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

Translate

Forum|alt.badge.img+6
  • Nintex Partner
  • May 2, 2017 5:19 PM UTC

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.

Translate