This maybe a bug, but it can be just that I don't know how to set up correctly:
I added the following components on the form: IBDatabase1, IBTransaction1, IBQuery1 and IBUpdateSQL1.
I set the following in Object inspector:
- IBDatabase1.DatabaseName = localhost:sampledb (I have sampledb listed in aliases.conf file in Firebird installation folder),
- IBTransaction1.DefaultDatabase = IBDatabase1,
- IBQuery1.Database = IBDatabase1,
- IBQuery1.Transaction = IBTransaction1
- IBQuery1.UpdateSQL = IBUpdateSQL1
Then I added some select statement to IBQuery1.SQL. The select query works well. Now I want to set up the IBUpdateSQL1 component, but when I try to edit any of its sql properties (delete, modify, insert, refresh), I get "No Default Transaction" message box!
There is no Transaction property of IBUpdateSQL. And I belive that there should not be this property, as the IBUpdateSQL component has the IBQuery, which has its Transaction property.
Is it a bug or I'm doing something wrong?