Stored Procedures in PowerBuilder 9

View: New views
1 Messages — Rating Filter:   Alert me  

Stored Procedures in PowerBuilder 9

by mmarconi :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Hello.

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
1

Thanks


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe:    http://lists.mysql.com/win32?unsub=lists@...

LightInTheBox - Buy quality products at wholesale price