Problem with a stored procedure to insert my form database

Suite and Optimus Suite 5
#1

Hi all,

I have a stored procétude works fine on my DBMS, but when I call it with render_complex_sql () of dhtmlx I got errors.
Here is my procedure:

fj_save_annee(integer, character varying, date, date);

here calling this procedure:

$gridConn->render_complex_sql("exec fj_save_annee","id","nom,debut,fin");

Here is the error encountered

2013-02-22 17:06:02 GMT LOG: n’a pas pu recevoir les données du client : Unknown winsock error 10061
2013-02-22 17:06:02 GMT LOG: fin de fichier (EOF) inattendue de la connexion du client
2013-02-22 17:06:04 GMT ERREUR: erreur de syntaxe sur ou près de « ( » au caractère 13
2013-02-22 17:06:04 GMT INSTRUCTION : INSERT INTO (nom,debut,fin) VALUES (‘ddddddddddddd’,‘2013-02-13’,‘2013-02-19’)

I have been here two days, can anyone help me ?
What is the instruction that calls a stored procedure to inserrer data in my database?

thank you for giving me some of your precious time

#2

The render_complex_sql is purposed for data loading only, but if you have initialized client side dataprocessor for the same connector file - it will try to autogenerate insert query which will fail, similar to your case.

If you need to use some custom saving logic - you can do it by server side events, or by custom sql for related operations.

docs.dhtmlx.com/doku.php?id=dhtm … t_handling
docs.dhtmlx.com/doku.php?id=dhtm … date_event
docs.dhtmlx.com/doku.php?id=dhtm … _an_action