How can I load, insert and update data from different tables

Suite and Optimus Suite 5
#1

Hello,

I’m using dhtmlxScheduler with Connector and dataProcessor on JAVA.
I have 2 different tables in my DB. And I’d like to load DataA and DataB from tableA, and DataC and DataD from tableB. Insert or upload data to the appropriate table.

Thank you very much.
Alex

#2

You can use render_complex_sql command, with sql selecting necessary fields and joining | union necessary tables. But it will work only for data loading ( connector will not be able to create automatic sql update commands, you still can assign custom code to update handler and provide your own logic for data saving )

#3

Stanislav,
Thank you for answer.
I will try to do that.

Regards,
Alex