Query open

[Grubi]

Hi we are evaluating DOA and have the following question.

How is it possible to determine if a TQuery is open or not (Execute was Called) ?

Thank's.
Regards.
Grubi.

[This message has been edited by Grubi (edited 11 September 2003).]

 

[Marco Kalter]

For a select statement you can inspect Eof. For other statements the query is not really "open". The underlying cursor may be open, but that should not really be relevant to your application logic.

------------------
Marco Kalter
Allround Automations

 

[Grubi]

Originally posted by mkalter:
For a select statement you can inspect Eof.

Does this mean, that a query which reaches eof is automatically closed ? If not this would not work.

Edit:::
Ok seems that calling Execute and Close multiple times does no harm so you will not need to now the state either.

[This message has been edited by Grubi (edited 11 September 2003).]