FB2 & ZL 6.6.2

ilboss · Post by **ilboss** » 19.11.2007, 12:52

Hi,
I'm testing ZL 6.6.2 and Firebird 2.0 with Delphi 2007.
I try to explain my problem (sorry for my english)

Tab1 had a trigger. this trigger start a Stored procedure that populates Tab2 and Tab3

I insert a record in Tab1, and the SP and I populated with data Tab2 and Tab3.

Everything works perfectly in FB but ....
When I do it from D2007 I not seem to see the data Tab2 and Tab3 even
with a refresh.
To see the data I have to close and reopen the connection to the db.
This, of course, takes away a bit of time.

Some suggestions?
Thanks
Boss

Post by **mdaems** » 19.11.2007, 15:37

Hi,

As far as I know this has something to do with transaction handling in FB (Isolation level, hard/soft commits, ...).
It's a bit strange for me (using oracle and mysql). Are all queries using the same connection? Seems to me they should all have access to the same (updated) data, but apparently not.

Mark

ilboss · Post by **ilboss** » 19.11.2007, 18:00

> Are all queries using the same connection?
Yes, I'm using the same connection.
Do you thing it's better using different connection in this case?
thank's
Boss

Post by **mdaems** » 20.11.2007, 08:23

Apparently in FB a query can only get updated values after the updating transaction has been finished. Even within the same connection. As I understood a Commit is sufficient for most databases, but in FB it might be necessary to close the connection anyway. Something about hard and soft commits, I think.
(Search the forum on 'Firebird' and 'Commit', there's plenty of stuff about it)
So a different connection could be unsufficient.

Mark

ilboss · Post by **ilboss** » 20.11.2007, 12:01

thank's for yor help
bye
Boss