Open state of TOracleQuery

[edelklaus]

Hello there!

I have to check whether a selcet-statement via an TOracleQuery is "opened" or not. Since TOracleQuery ha sno "active" property the only way to achive this I found is to implement an try-except block. Within that I try to access a field of the query. If the TOracelQuery is open everthing is fine. If not, an exception is raised so that I can do in the exception part what is neccesary to open the query.

Some other ideas?

Thanks in advance,

Klaus

 

[Marco Kalter]

If you want to know if there are any records, your can use the Eof property.

 

[edelklaus]

Thanks, Marco!

But this means, that there's no way to check if the Select-statement in the TOracelquery has been executed (is open now)?

By, Klaus

 

[Marco Kalter]

There is indeed no property that will tell you if the current SQL has been executed.