G'Day All,

I have a class(TObject) which has a private variable which is declared as:

private
  FDataSet : TADOQuery;

The class uses that variable to retrieve / maintain information from a SQL
Server database. When the class is created I instantiate FDataSet and use it
to retrieve some info from the DB. If I have a look at the State property it
is dsBrowse (as expected). If I however go to use it again the State has
changed to dsInactive. At no point have I destroyed the class and the only
.Close method is in the destroy method of the class. There is NO way to
access this variable as it is private to the class. Timeout should not have
an affect as the dataset is opened in under 30s (default timeout for ADO
comps). How / Why is the state changing? Any suggestions or ideas? Any ideas
on how I could set up a break point to figure out where this is happening?

TIA

------------------------------------------------------------------------
--Donovan
Donovan J. Edye [www.edye.wattle.id.au]
Namadgi Systems, Delphi Developer
Web: www.namsys.com.au E-Mail: [EMAIL PROTECTED]
Voice: +61 2 6285-3460 Fax: +61 2 6285-3459
TVisualBasic = Class(None);
GExplorer [http://www.gexperts.com/gxexplorer/] Freeware Windows Explorer
replacement. Also includes freeware delphi windows explorer components.
------------------------------------------------------------------------

---------------------------------------------------------------------------
    New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
                  Website: http://www.delphi.org.nz

Reply via email to