Hello.

I have s sybase stored procedure which accepts several input parameters and one input/output parameter.

I try to execute it as it would be usual agains SQL server but nothing happens, no recordset returned and no way to get the output value back to FoxPro.

I'm connecting thru ODBC driver, and run simple "select * from" but calling the stored procedure seems to do nothing


I have found that more people get in trouble trying to make it work but I don't get a clear example to solve my next example.

From Sybase, the stored procedure is called this way:

declare @msg varchar(200)
exec sp_test @operation = 'C', @key = '13290000000009', @msg=@msg out
select @mensaje

IT normally returns a record and a response string into @msg

Does anyone know how to do this from FoxPro by using ODBC connections?
Thanks,
Juan C.