General information
Title:
Calling Sybase stored procedure from VFP (ODBC connection)
Environment versions
Network:
Windows 2003 Server
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.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only