This code addresses the issue of getting the return value. However, it does nto address trapping the values of any Output Parameters. See my response to Curtis which I copied you on for details...
>>I'm trying to run a stored procedure on SQL Server and get back a return value and the value of a parameter that has been changed. The problem with this is that I can see how to do this in Transact SQL, but I'm not doing too well in VFP6.
>>
>>Can anyone tell me how to do this and/or point me to a good reference on how to do these things?
>>
>>TIA,
>
>lcParam1 = Value1
>lcParam2 = Value2
>lcProcedure = "Exec SP_ProcedureName ?lcParam1, ?lcParam2"
>lnResult = sqlexec(SqlHandleNo, lcProcedure, "MyCursor")
>if lnResult < 0
> Messagebox("No data selected . Connection Falure", 64, thisform.caption)
> return
>endif
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only