At present I have a terrible problem and the fact is that I am executing a procedure in the database that carries out the process of billing (that is to say splits the order in ‘n’ pages, brings up to date the movement of the inventory, brings up to date the client etc.) , This procedure functions perfect in Interactive SQL of Sybase (Window to execute commands of SQL and scripts).
When I call the procedure from Servoy with plugins.rawSQL.executeStoredProcedure the procedure functions well
( when the bill has few items 10,35,80 functions well but when the bill has more than 100 items never finishes the procedure
and as I utilize Begin Transaction… rollback, when I leave Servoy Developer the procedure is rolled back )
I am working with Servoy 411 but I utilize SQL Anywhere 902, to my seems me that I lack to adjust some parameter, but I’m tired to seek in the documentation ( which seems me very poor ).
The software seems myself extraordinary, but at present I am paralyzed because I do not find solution for this problem.
For me it is vital to execute procedures from Servoy many of which already are facts because I am emigrating my application
of Visual foxpro 8 and SQL Anywhere 902 ( that certainly the database functions extraordinarily well ).
Even I emigrated the database SQL Anywhere from 902 to 10.0.1 but there is no change.
Greetings Armin Kessler
gen_bill.txt (10.7 KB)