FiveTech Support Forums

FiveWin / Harbour / xBase community
Board index FiveWin for Harbour/xHarbour Disconnected Recordset ADO
Posts: 408
Joined: Sun Nov 06, 2005 03:55 PM
Disconnected Recordset ADO
Posted: Sun Sep 23, 2007 07:25 PM

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

Thanks,

Byron Hopp

Matrix Computer Services
Posts: 2706
Joined: Fri Oct 07, 2005 01:50 PM
Disconnected Recordset ADO
Posted: Sun Sep 23, 2007 10:15 PM

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

Posts: 10733
Joined: Sun Nov 19, 2006 05:22 AM
Disconnected Recordset ADO
Posted: Mon Sep 24, 2007 02:53 AM

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

Regards



G. N. Rao.

Hyderabad, India
Posts: 408
Joined: Sun Nov 06, 2005 03:55 PM
Disconnected Recordset.
Posted: Wed Sep 26, 2007 05:51 PM

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 ,

Thanks,

Byron Hopp

Matrix Computer Services

Continue the discussion