+7
I have SQL service instance that has been in use for a long time and it has tables that have CRUD and list methods but I recently create a new table, refreshed the service instance and the new table appears but it has only a list methods. Not sure how this started I had another database that was created when we were on 4.6.9 and new tables there also now only have a list method.
I have checked permissions on the service account and it has DBO
We are on 4.6.11. Does nayone have any ideas?
Does this table have a Primary Key column?
https://www.k2.com/onlinehelp/k2blackpearl/userguide/current/webframe.html#tables.html
Dear ,
R u using sql server tables ? to generate smart objects ,
or r u using SmartBox ?
both ways tho , from wt u r saying , u are only able to read from these tables , u cant CUD from them , so only thing i think of is that u dont have the permissions on the data base to create / update / delete .
please check the permissions then refresh the db service instance .
Regards.
+7
Not having a primary key seems to have been the problem. Thanks Tin
I created a table with primary key and it worked. It was not a permissions issue.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
