Skip to main content

I have a SQL table with user details and i have an editable list created from this.

i would like to edit rows in the list, and then save my changes to another SQL table

what is the best method for achieving this?

HI braddo,


 


I have provided you with two links that would help with editable list view,please view the link sbelow .


http://help.k2.com/onlinehelp/k2five/userguide/5.1/default.htm#Create/Views/EditingAView.htm%3FTocPath%3DCreate%7CSmartForms%7CViews%7C_____3


 


http://help.k2.com/onlinehelp/k2five/userguide/5.1/default.htm#Create/Views/EditableListViews.htm%3FTocPath%3DCreate%7CSmartForms%7CViews%7CList%2520Views%7C_____3


 


Hopefully the content will remedy your issue, or direct you you to the right path of  solving it.


 


NOTE: K2 will not accept any liability for any issues arising from actions taken in respect of the information provided by any forum member.


Hi Braddo,


 


You will have to change your SAVE button rules to save all the entries to a new SmartObject.


 


e.g.


 


I created 2 SmartObject (Emp1 & Emp2) and generated an Editable List View from Emp1 (This SMO also contains some data):


 



 


 


I edited the following rule: When Save Toolbar Button is clicked


 


I disabled the 3 actions and added the following condition & method on the rule:


for ALL rows


     then on [SMO2] SmartObject, execute its Create method


 



 


Runtime:


The first View opens and i can make changes as i want:


 



 


Click SAVE and look at the data in the Second SmartObject in the Database.


 



 


HTH


 


-Jean


I had discovered this method - does this make sense to you?

on the editable list i make changes

Rule

when the view executed list item changed

apply the changes made to the row on the editable list

 

then i have a submit button on the form

and then the rule

On the view, using Smartobject, execute the create method for all the items that have been changed


Reply