RE: Getting Return Values from Stored Procedures

I can successfully return SP values using RDO & VB5. Not sure if that will help... -----Original Message----- From: Michael W. Lester [mailto:lesterm@usaa.com] Sent: Thursday, May 28, 1998 8:49 AM To: informix-list@iiug.org Subject: Getting Return Values from Stored Procedures Help! I am unable to get return values from a stored procedure back to a VB client connecting thru ODBC. (I've experienced this with both 16 bit INET / ODBC and 32 bit IConnect / Intersolv ODBC 3.0 using VB 3.0, VB 4.0 32 bit, and VB 5.0. My version of OnLine is 5.0. ) If I use the following VB code, I can capture the 1st return value, but other columns come back null even though the function returns actual values. '--------------------------------------------------------------------------- ---------------- 'VB 4.0 or greater code set rs = db.openrecordset("execute procedure this_bytes( parm1, parm1);" , dbopenSnapshot, dbSqlPassthrough ); msgbox rs(0) ' ---- Contains the SPL's first return value msgbox rs(1) ' --- Contains NULL, even though the SPL returns a value. '--------------------------------------------------------------------------- ----------------- I've been using a hack for some time where I make the SPL build a string of delimited values and return everything in one big string to be parsed by the client. This is getting old! Has anyone experienced this, and do you have a better workaround to get values back from SPL? Any tips are most appreciated... Mike Lester USAA Investment Management Company