Hi @JulieBird,
In order to get the other methods (create, read, update, delete), your SQL tables must have primary keys. Incase you are doubtful of your service instance setup, please look at this document. As for the primary key, if you dont want to delete your table/s and re-create them with primary keys, I recommend that you look into some “alter table” sql queries in order to make a field/column a primary key field. You might find this useful:
https://www.w3schools.com/sql/sql_primarykey.ASP
Hope this helps :)
Kind Regards
Prineel
Please check it out to create advanced sql server smartobjects
https://help.k2.com/onlinehelp/classic/userguide/5.4/default.htm#How-Tos/AdvancedSmartObjects/SQLServer/CreateAdvSmartObject-SQL.htm
Table object (with primary key), The generated smartobject have method list, read, update, delete, create
Stored procedure object, the generated smartobject has method Execute.
View object, the generated smartobject has method List.
You can generate List method from stored procedure smartobjects (sometimes a bit tricky in complex stored procedure)
- ensure SET NOCOUNT ON
- stored procedure just simply return query results or,
- stored procedure output record from function table or,
- for complex stored procedure with ton’s of logic, you can use variable table to stored processing result then later do select statement on the last line.
