How do you execute Update or Create Method when the SQL table is a List?

  • 2 December 2014
  • 2 replies
  • 1 view

Badge +1

Hi,

 

I have a SQL table that is a list method. I need to be able to execute methods update and create to post data to a SQL log table. When I execute a smart object method the only choice I have is List. How can I use create or update? Is it even possible?

 

Thanks,

Bones


2 replies

Badge +8

The SQL service broker should provide those methods if the service broker user has INSERT or UPDATE permissions on the table.

Badge +2

Also, create the identity column in the table. May be a  id column as identity column (autonumber). Save the table and RefreshSQL server service instance. It should show you CRUD methds then.

Reply