Multi-Table update

Suite and Optimus Suite 5
#1

The Java Connector document example below:

if(gridConn.is_select_mode()){//code for loading data gridConn.render_sql("Select * from tableA, tableB where tableA.id=tableB.id", "a.id","name,price,other"); }else{//code for other operations - i.e. update/insert/delete gridConn.render_table("tableA","id","name,price"); }

What should I do if tableB is also need update when editing occur?
And another question is, if both tableA and tableB need update, could I do the two steps(update record in database) in one transaction?

#2

If you need to update both tables then you will need to define your own logic.

docs.dhtmlx.com/connector__java_ … lexqueries

Check the beforeUpdate part of the above snippet. In similar way you can provide your own data saving rules.