MIDRANGE dot COM Mailing List Archive



Home » MIDRANGE-L » February 1998

VB4, Client Access & stored procedures


  • Subject: VB4, Client Access & stored procedures
  • From: "Rina A.Wiese" <rina@xxxxxxxxx>
  • Date: Sat, 28 Feb 1998 11:42:41 +0100

fixed

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
+---






Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2014 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact