List:MySQL on Win32« Previous MessageNext Message »
From:mmarconi Date:June 17 2008 8:57pm
Subject:Stored Procedures in PowerBuilder 9
View as plain text  

I'am starting with mysql, chanching an aplication that runs on sybase.
Have problems to call stored procedures from de powerbuilder code ( the
strored procedures run perfectly called from mysql browser).

This is de script in powerbuilder :

DECLARE pru PROCEDURE FOR sp_pru ( 'arg1' ) ;
execute pru  ;

mysql returns :
SQLSTATE = 37000
[MySQL][ODBC 3.51 Driver][mysqld-5.0.45-community-nt]You have an error in
your SQL syntax; check the manual that corresponds to your MySQL server
version for the right syntax to use near '{call sp_prueba( 'arg1'}' at line


Stored Procedures in PowerBuilder 9mmarconi17 Jun