Disconnected Recordset ADO

[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...

[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

[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

[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 ,