Insert/Update/Delete into more than one table

Suite and Optimus Suite 5
#1

Will insert/update/delete into more than one table be supported in the next release?

Does dhtmlxConnector support m-to-m relations for insert/update/delete?

#2

We not plan to support multi-table operations in foreseen future.
Connectors provide ability to attach custom code for each kind of operation, so you can implement multi-table operations with minimal efforts.

Does dhtmlxConnector support m-to-m relations
Not supported. This kind of linking is not used in any of dhtmlx components, so there is no server side support for it as well.

#3

Thanks for your fast reply.

#4

You can update two different tables using current version of dataprocessor settting up 2 dataprocessors

ex : render_sql (select a,b,c,d,e,f from table1,table2 where table1.a = table2.a,“a”,“b,c,d,e,f”);
this is for select mode

in the grid, defin column IDs : grid.setColumnIds(“xxx,xxx,xxx…”);
I usually use DATABASE FIELD NAMES

for update :
define the first dp and setDataColumns
dp.enablePartialDataSend(true);
dp.enableDataNames(true);
dp.setDataColumns([true,true,true,false,false]);
This way, only the 3 firsts columns will trigger dataproc

define the second dp
dp2.enablePartialDataSend(true);
dp2.enableDataNames(true);
dp2.setDataColumns([false,false,false,true,true]);
this way, the 2 lasts fields will trigger the dataproc.

both tables MUST share the same key (a in the the exemple).

There you go, it works for me… if somebody may help me whith date formats and oracle NLS param…