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
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement