Insert, Update 2 tables

Suite and Optimus Suite 5
#1

hello

I need please insert and update in diferent tables

example

$data->render_table(“mn_mfarmacias”,“con”,“nombre,sucursal,direccion,telefono,id_depto,id_ciudad,nit”);
$id_punto->sql->get_new_id();
$data->render_table(“mn_musuarios”,“id”,“id_punto, nombre,sucursal,’’,’’,‘2’,‘1’,‘360’,now()”);

Not working , only inserted in, mn_mfarmacias

thanks.

#2

Hello,

there can be only one render_table (or render_sql) call in connector script. You can try to set “onBeforeInsert” and “onBeforeUpdate” handlers to execute custom logic on “insert” and “update”. Please read the following docs:

docs.dhtmlx.com/doku.php?id=dhtm … ex_queries