benpartlow
Feb 17th, 2000, 10:16 PM
am using a MSRDC data control to connect to an INFORMIX database. I have been using the following code successfully so far:
Dim my_sql as String
Dim x as Long
my_sql = "Select whatever From whatever ...."
MSRDC_name.SQL = my_sql
MSRDC.Refresh
x = MSRDC_name.resultset(0)
The ".resultset(0)" references the first value returned by the query and that value is successfully assigned to "x". I get an error when trying to reference subsequent returns as in
".resultset(1)" for the second value returned. The query definitely returning multiple values, so it is not a matter of the second value not existing.
Thanks.
Dim my_sql as String
Dim x as Long
my_sql = "Select whatever From whatever ...."
MSRDC_name.SQL = my_sql
MSRDC.Refresh
x = MSRDC_name.resultset(0)
The ".resultset(0)" references the first value returned by the query and that value is successfully assigned to "x". I get an error when trying to reference subsequent returns as in
".resultset(1)" for the second value returned. The query definitely returning multiple values, so it is not a matter of the second value not existing.
Thanks.