BorlandTalk.com

davidary@msn.com · Guest

Hi,

I am maintaining an application written in Delphi, using dbExpress to
connect to Informix Engine (9.x). We are using Borland's dbExpress
driver for Informix, dbexpinf.dll Version 7.0.2.113.

I am wondering whether there is a known issue in the Borland dbExpress
driver for Informix, where intermittently, it appears as if
ApplyUpdates is successfull (even get a valid read back), but it never
actually hit the database?

Because we have seen that most of the time it works fine, but
intermittently we noticed that whole bunch of records (in multiple
tables) that we know already written to database are missing. There is
no trace at all that those records ever written to database. We
conclude this based on the fact that we do a read / query after a
successful call to ApplyUpdates and we get the value we just written.
We also put trigger on the database that log whenever the tables gets
inserted/updated (with timestamp), and we don't see any records got
inserted or updated during a time frame where we have hard-copy proof
that we have succesfully called ApplyUpdate and get a value we just
written to database back.

We are really scratching our head in this one :-)

Thank you,

David Hadiprijanto