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?
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 .
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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.