Re: VB5 and Stored Procedures?

Don't know anything about VB5 but surely it will look more like: SQL = { call MySP(?) returning ?,? } ? Guy Dillen <guy.dillen@skynet.be> wrote in article <347EC0B9.11DA@skynet.be>... > 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 >