Hi all. I'm trying to exec a MySQL 5.0.20 stored procedure (which executes ok inside MySQL Administrator) thru MyODBC 3.51.12, but I always get an error.
The SP is defined like:
CREATE DEFINER=`root`@`%` FUNCTION `NumRecs`() RETURNS int(11)
SQL SECURITY INVOKER
COMMENT 'Prueba de Stored Procedure'
BEGIN
Declare nRecs Int;
Select Count(*) Into nRecs From NCH;
Return nRecs;
END
And in the VFP .prg:
h=SQLConnect("Necropolis")
If h>0
If SQLExec(h, "Call NumRecs();", "qRecs") < 0
AError(x)
MessageBox( x[3] )
EndIf
SQLDisconnect(h)
EndIf
TIA