VB5 and Stored Procedures?
I'm trying to call a Stored Procedure (sp) from Visual Basic 5.
My sp has 1 input parameter and returns 2 output parameters.
When I'm trying to call the sp I get the following message:
"Too many arguments passed to procedure".
I call the sp this way:
...
SQL = { call MySP(?, ?, ?) }
...
My Informix SP looks as follows:
create procedure MySP (a as CHAR(2)) RETURNING b as CHAR(30), c AS
CHAR(15)...
end procedure
When trying calling sp with 1 parameter, there is no problem. The
problem is related to the output parameters.
Anyone has a solution for calling sp from VB5?
Any help very much appreciated.
Guy Dillen