CREATE PROCEDURE usp_test @Number INT, @NewNumber INT OUTPUT AS SET @NewNumber = @Number + 3 RETURN @NewNumber GOIn VFP we have valid ADODB.Connection object oConn and some variables. I want to use connection's Execute method:
LOCAL lnIn AS Integer, lnOut AS Integer, lnReturn AS Integer lnIn=15 oConn.Execute("What?")What would be the correct syntax for:
lnReturn = oConn.usp_test(lnIn, @lnOut)I has not been able to get it working. Has anyone?