transaction and ibcquery destruction

calou · Post by **calou** » Thu 07 May 2009 12:37

Hello,

When i do this

ibcqry:=TIBCQuery.create(self)
ibcqry.SQL.Text:='....'
ibcqry.Open

An transaction is opened

If i do FreeAndNil(ibcqry) is the transaction is closed? if no what is the best way to close it?

Thanks

Regards

Plash · Post by **Plash** » Fri 08 May 2009 07:28

Transaction is not closed when you free TIBCQuery.

You should use the Commit or Rollback method of TIBCConnection or TIBCTransaction to close the transaction.