>>I don't know mySQL but looking at documentation (almost next to none) sounds like:
>>
text to lcSQL noshow
>>CREATE PROCEDURE sp_ww_NewID (cName char(30), out nRetval integer)
>> begin
>> UPDATE mytableids SET id = id + 1 WHERE TableName = cName;
>> select id from myTableIds where TableName = cName into nRetval;
>>end
>>endtext
>
>For some reason I still can't get the nRetval to update on the Fox side... it's like it's not recognized as being passed by reference. This routine runs without error but always returns the original value of nRetval, not the modified value as set in the SP.
>
>
>>PS: Wouldn't the call syntax be better like this:
>>
lcSQL="Execute sp_ww_NewId ?m.lcTableName,?@pnID"
>
>In MySQL you use Call instead of Execute for Stored Procedures and if I pass with the question mark as in ?@pnID I get the error message OUT or INOUT argument 2 for routine blah. is not a variable or NEW pseudo-variable in BEFORE trigger.
>
>
>Any other ideas?
If you run it in MySQL do you get correctly the OUT parameter?
If it's not broken, fix it until it is.
My Blog