Template Repeater update Dataset with a 'save' button

On a vision Window:

I have a template repeater with multiple text fields from Template Parameters (SQL Query). I have a save button on the page and I would like to edit and save entries to the SQl DB.

I tried to do a property change script on the template (on L-Level) but this changed both rows of dataset (ie changed both deliveries).

Any tips. (FYI.. I am anew guy with scripting.)

Hi Keyur,

You can run queries by adding a script on a button and supply the values you need it from the property refence button. You can call a function like system.db.runNamedQuery or system.db.runPrepQuery to add the data to the database. I have a picture below for your reference for selecting values from your Window.

Best!

1 Like