executeStoredProcedure Don't work

Classic Servoy
1

If someone have experience with executeStoredProcedure with SQL Anywhere 9.02.

I use call to stored procedure in my application with VisualFoxPro.

I am new in Servoy and I trying to run a method that use executeStoredProcedure to insert a record in the database.

In the attached file is the code of the method and stored procedure.

The method execute and don’t display error but do not insert the record.

Thanks Armin Kessler

The Code.doc (21.5 KB)

2

Armin,

Your test for the exception is wrong.

if ( ! plugins.rawSQL.getException() == null )

should be

if ( ! (plugins.rawSQL.getException() == null) )

or

if ( plugins.rawSQL.getException() != null )

Rob