Oracle update

Suite and Optimus Suite 5
#1

Hello,

Could you please tell me why the following code doesn’t work:

connector.php:

...
$grid->enable_log("tmp.log",true);
$grid->render_sql("SELECT toip_job.DETAIL, toip_job.ACTION_TYPE, toip_job_detail.DATA2,toip_job_detail.DATA3,toip_job_detail.DATA4,toip_job.STATUS_AFAIRE
 FROM toip_job, toip_job_detail where toip_job.STATUS_AVALIDER = '1' and toip_job.DETAIL = toip_job_detail.data1",
"DETAIL","DETAIL,ACTION_TYPE,DATA2,DATA3,DATA4,STATUS_AFAIRE");
...

When i try to update from the grid the .log returns:

It was ok with mysql database.

Thanks for your help.

#2

The autogenerated queries works fine for render_table, but when you are using render_sql it not possible to build correct SQL update automatically. Code tries its best, but result SQL update will not guaranteed to work.

You can use custom update logic.
docs.dhtmlx.com/doku.php?id=dhtm … ex_updates