In SQL Server I'm using this way
lcSQL = 'execute dbo.mySP @myInputParam = ?m.FirstParam, @MySecondParam = ?@SecondParam OUTPUT'
Wondering if this can somehow help figuring this out.
>Hi James,
>
>Nothing works, tried all variations:
>lcsql = [call proctest(?abc,?retv)]
>sqlexec(gnhandle,lcsql)
>
>lcsql = [call proctest(abc,?@retv)]
>
>lcsql = [call proctest(abc,retv)]
>
>lcsql = [call proctest(abc,?retv)]
>
>None of the above scenarios will work.
>
>I just decided to just retrieve the cursor. Somehow, returning parameters from mysql is a mystery for me.
>
>Thanks for your reply.
>
>Joy
If it's not broken, fix it until it is.
My Blog