VB4, Client Access & stored procedures

Hi,
We are using Visual Basic 4.0, Client Access ODBC Windows 95/NT to
Stored Procedures and ILE RPG at OS/400 V3.7. Our application requires
multiple result sets. All the reading we have done says that we should
use Array Result Sets.

We have followed the procedures laid down in the AS/400 Client/Server
Performance Redbook (SG24-4731-00) (which is at VB 3.0) and have that
working for a single array result set.
The ODBC Users Guide indicates that on the host side we can identify/use
up to 20 results sets with the 'SET RESULTS SETS' statement (but only
one array).

When we tried to work this up for our application by receiving 2 Array
Result Sets in the Visual Basic program, we receive only the second
result set.
The host side is quite clear and it is passing out 2 result sets.
On the client side in the 'CREATE PROCEDURE' statement we have
(for this case) specified 'RESULT SETS 2', and we know about
SqlMoreResults.
We also have Mike Otteys book on the subject.
Can somebody on this list help?  We cannot see what else we should do
on the Visual Basic side to process all the result sets the host is sending.

Kind Regards,
Rina Wiese
rina@xs4all.nl


+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to "MIDRANGE-L@midrange.com".
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---