CREATE PROCEDURE usp_test @Number INT AS SELECT @Number + 3 GOis being called from VFP the following way
loRS = oData.oConn.Execute("usp_Test 3") ?loRS.Fields(0).Value &&returns 6Works fine.
CREATE PROCEDURE usp_dsp_TooLate2AddInvoice @Drv_CD CHAR(8) AS DECLARE @TooLate BIT DECLARE @RecordsCheckedOut INT DECLARE @LatestCheckOut DATETIME SELECT @RecordsCheckedOut = COUNT(*) FROM dspCOutH WHERE Driver_CD = @Drv_CD AND Out_Dt IS NOT NULL IF @RecordsCheckedOut = 0 SET @TooLate = 0 ELSE BEGIN SELECT @LatestCheckOut = MAX(Out_DT) FROM dspCOutH WHERE Driver_CD = @Drv_CD IF DATEADD(ss, 300, @LatestCheckOut) > GETDATE() SET @TooLate = 0 ELSE SET @TooLate = 1 END SELECT @TooLate GOis being called from VFP the same way
loRS = oData.oConn.Execute("usp_dsp_TooLate2AddInvoice '1001'") ?loRS.Fields(0).Value &errorgives error "Member FIELDS does not evaluate to an object".
lcDriver = '1001' loRS = oData.Call_SP("usp_dsp_TooLate2AddInvoice lcDriver")