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 ,