July 19th, 2004, 01:32 PM
|
|
Registered User
|
|
Join Date: Jul 2004
Posts: 1
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
|
Returning ADO Recordset from a Function
Hello, I have a function (QueryDB) that uses a com object written in vb to access a MySQL database. I want to return the recordset from QueryDB to the calling function and then be able to access the fields. Is this possible? Here is the code:
oRS = utility.QueryDB(self.PROD_DB, sSQL)
self.config = oRS.Fields("CONFIG").Value
self.seq = oRS.Fields("SEQUENCE").Value
From utility.QueryDB:
Return oRS
If I examine the contents of the RS in QueryDB, the data is correct.
|
Dev Shed Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
