Informix and calling Stored Procedures

Hello Informix/VB developers, Yesterday Here is the solution:I posted a question how to call an Informix Stored Procedure from VB5. Well I found a solution for it. Informix is different with e.g. Microsoft SQL Server and some other databases in the sense that Informix has not output parameters. Therefore I always got an error when giving more (the output parameters) with my call. So you can only give the input parameters with the call. Example: dim ... SQL = {call mysp (?)} -- one input paramater SQL = {call mysp (?, ?, ?) -- one input, two output parameters DOESN'T work ... ... do until rs.eof list1.additem rs(0) & "," & rs(1) -- these are the output parameters -- from Informix. No named parameters; -- and Informix only works with index -- parameters (eg.s(0)) rs.movenext loop Best regards, Guy Dillen Information Technology Partners Belgium ;;;