Information générale
Forum:
Microsoft SQL Server
Shawn, I never could figure out how to do that in VFP. I always use output variables, which are easy to set up and work fine in VFP. If you assign a value to the variable in VFP, then designate it as an output variable in your SQL stored proc and the call to that proc, SQLEXEC() will change the value of your VFP variable.
>I need to know if this code will return a value back to me
>
>DECLARE @TransNumber int
>update control set @TransNumber=txnum=txnum+1
>return @TransNumber
>
>i call this from FoxPro with an sqlexec()
>how do i get the value back from the server with the above statement.
>
>TIA
>SHAWN
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