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