+7
Hi
I have created a SQL Table and have added the SQL SMO to a form using the create method and now I am not seeing any Output mappings the methods on the right hand side are all empty. what have I done wrong, is this a SQL table creation problem or what have I done here wrong. any help would be great!
Best answer by CraigBrook
View originalGood day Craig
Jus a few questions to ensure the prosess.
1. Have you craated the SMO form a service instance through management or the SMO Tester tool?
2. Does the table have a primary key? Methods like Get Item, Update, Delete etc need a primary key to perform.
3. Did you refrese the service instance after the table was created?
4. Will it be possible to provide a screenshot of the empty output mappings?
Best Regards
Jacques.
Hi
Could you please relate your situation with this(https://community.k2.com/t5/K2-blackpearl-Articles/Smartobject-missing-properties-on-Output-Mapping/ta-p/84627?nobounce)
Additionally(http://synegrate.blogspot.com/2014/11/how-to-use-check-box-list-using.html), however i suggest you attach screenshot of what you are going through as jac said.
Should you find any of the above content useful and/or leading you to the answer Kindly mark such as "Kudo and/or Accepted",express how you tackled the issue.
Thanks & Regards;
Widson.
+7
Hi
I found the problem, it was SQL related, as I thought.. When I created the table I didnt have the parameter "Identity(1,1) or autogenerate ID on the first time, I went back in SQL Mgr and added it but and republished the SMO, but the service did not refresh, I went back in and refreshed the service instance and then the return property appeared in the output mappings in my form and workflow.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.