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