Hi,

I want to return values from my SQL 7 stored procs to VFP. I am aware of the rather cryptic (and undocumented as far as I can tell) syntax:

= SQLEXEC( lnHandle, '{ CALL myproc (parm1, parm2, ?@myvar) }' ) . . . which works , but ... welll - two questions ...

1) C'mon - there has GOT to be a better way than that!

2) I still see no way to get the integer return value from a SQL Stored Proc - example: if my stored proc does something along the lines of:

IF @test = 'somevalue'
RETURN 1
ELSE
RETURN 0

I see no way to retrieve that 1 or 0 into VFP without putting it into an ouput parameter, which kind of defeats the purpose of RETURNing it in the first place. I am seeking to write stored procs that work equally well and consistently whether called from VFP or within T-SQL

Any ideas on either of these questions anyone?

thanks,
Ken