how to use stored procedures save data into dhtmlxGrid

helen2012 · October 1, 2012, 8:49pm

HI,
Does any body know how to pass parameters into stored procedures from dhtmlxGrid? I can’t find sample code in the grid.

thanks
helen

Stanislav · October 2, 2012, 10:03am

In case of php connectors, you can use render_complex_sql, similar to

$grid->render_complex_sql(“CALL procedure_name()”, “id”, “name, price”);

unfortunately it will work only for data loading, if you wish to use stored procedures for saving, you can use custom sql queries, like

$grid->sql->attach(“Update”,“call some_proc(’{name}’,{price},{id}”);