Page 1 of 1
Disconnected Recordset ADO
Posted: Sun Sep 23, 2007 7:25 pm
by byron.hopp
Does anybody know how to disconnect a recordset in FiveWin / xHarbour.
In VB its
Set oRs.ActiveConnection = Nothing
In FiveWin / xHarbour
oRs:ActiveConnection := Nil // does not work.
oRs:ActiveConnection := "" // does not work.
Thanks,
Byron...
Posted: Sun Sep 23, 2007 10:15 pm
by Rick Lipkin
oRs:Close()
I wrote a thread compiled from my questions .. hope this helps:
http://fivetechsoft.com/forums/viewtopi ... highlight=
Rick Lipkin
SC Dept of Health, USA
Posted: Mon Sep 24, 2007 2:53 am
by nageswaragunupudi
This is the working solution:
oRs:oConnection:hObj := NIL
I am using this for disconnected recordsets.
You can save the value of hObj and reassign to get reconnected
NageswaraRao
Disconnected Recordset.
Posted: Wed Sep 26, 2007 5:51 pm
by byron.hopp
Thanks,
oRs:ActiveConnection:hObj := nil
Works,
I see no reference of an hObj instance variable off the ActiveConnection propertity. How do you know this stuff, is there some defaults about all of these propertities and methods that would be helpful to know. Any information would be greatly appreciated.
Again your solution did work.
Thank you ,