Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Returning a recordset
Message
From
05/10/2000 05:56:15
 
 
To
05/10/2000 03:26:47
General information
Forum:
Visual FoxPro
Category:
Internet applications
Miscellaneous
Thread ID:
00425175
Message ID:
00425188
Views:
27
Hi Benn

"oConn.Close" is creating the problem. If you close the connection, the recordset which is bounded by "oRecordset.ActiveConnection = oConn" also closed.

You can also open the connection in recordset itself like :

oRecordset.Open("SELECT * FROM Freetime","DRIVER=Microsoft Visual FoxPro Driver;" + ;
"SourceType=DBC;SourceDB=D:\DATA\VFP_60\OLE\ADO.DBC;" + ;
"Exclusive=NO;BackGroundFetch=NO;NULL=NO;Collate=MACHINE")

HTH
- Ram.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform