Data binding grid->sql->dataview how?

Suite and Optimus Suite 5
#1

Hello ,

I have a grid which presents some data taken from my SQL table , additionally to that I have data view form in a separate tab which shows extended information for the selected item (id) in the grid (I query sql for extra info based on the received id and show it in the data view). How can I enable auto sync of data between grid and data view via sql? I.e if I change data in the grid I would like to see that data to be immediately synced to SQL (that works fine) … and also updated in the dataview form? Unfortunately I dont see any examples on the web page .

I appreciate in advance your help.
Thanks
Igor

#2

Hello,

and also updated in the dataview form? Unfortunately I dont see any examples on the web page .

After the response for grid update request is received, you may update dataview.

dataview.clearAll();
dataview.load(…);

If the response of grid update contains data for dataview, you need use parse method instead of load

dataview.clearAll();
dataview.parse(…);