No ratings

SmartObjects based on SQL tables containing 'periods' does not generate CRUD methods


SmartObjects based on SQL tables containing a period, does not generate CRUD methods

This article was created in response to a support issue logged with K2. The content may include typographical errors and may be revised at any time without notice. This article is not considered official documentation for K2 software and is provided "as is" with no warranties.


When you generate an SQL table name that contains periods/dots and you generate a SmartObject based on that table, the SmartObject will only have a "list" method. 


The CRUD methods (Create, Read, Update and Delete) will not be auto generated for you.


As an example, if you create an SQL table, with the name dbo.Employee.Information:



This will result in a SmartObject that has a "List" method only:



As a workaround, you can use an underscore, instead of a period.



When doing this, K2 will generate the list, and all of the CRUD methods for you, as expected.



Please see the "Considerations" section in the following article for more information: 


We have logged an item for the development team to look at. If deemed viable, this issue should be addressed in a future release of K2. 


Labels: (2)
Version history
Last update:
‎05-19-2021 04:27 PM
Updated by: