Symptoms
This was a How-To type ticket in which the user needed to create smart objects against a SQL database and create and editable list view.
Diagnoses
N/A
Resolution
Building SQL SmartObject
1) In K2 Management, drill down into SmartObject AdministrationandgtandgtService Instance
2) Add a new instance of the type 'SQL Server Service' and connect it to you SQL server instance
3) You can select to generate SmartObjects here
Editable list view
Please consult this community article:
http://community.k2.com/t5/K2-Appit/Creating-an-editable-list-view/ta-p/75849
But we can use SQL View in an editable list editing the SmartObject of this View, go to its properties and then select Method tab. You will see a List method over there so add an update method binding to some table which is used in view. But keep one thing in mind whatever you want to do do it on your custom button don't update automatically. But if you are sure about the relations then you can go on. Best of Luck :)