ibcquery transaction

[calou]

Hello,

I use IBCQuery liked with an ibctransaction (properties by defaults)
Suppose I do that

IBCQuery .SQL.Text:='select * from ma table where COL='+QuotedStr('test');
IBCQuery.Open;

For the select, I don't use transaction. What happen if the sql code is wrong? What about the database? it is in a wrong state?

In these cases (read data, do SUM, do COUNT etc… but not write data) what is the best to do? Like above or use transaction to?

Thank you for help

Regards

[Plash]

The database will not be in the wrong state. You don't need to use transaction.