Hi,

At July 14, 2003, 13:59, Joe Martinez wrote:

> They will search for a record by the table's primary key (it uses a
> TIBOQuery). The search comes up as zero records found. So, then, they try
> to add the record (calling Insert on a TIBOTable connected to the same
> table, filling in the data aware controls, then calling Post()). This
> produces a Key Violation error. They try the search again, and it still
> says it isn't there, but every time they try to add a record with the same
> key, they keep getting the Key Violation.

It almost seems as if the transaction is not committed.

> If they exit my app, start it again, and try the serarch again, it finds
> it. So, it looks like it was there all along, but for some reason, the
> search wasn't finding it. I'm not sure why restarting my app makes it
> start working.

Possibly because the transaction gets committed!

> Does anyone have any idea what's causing this, or how to fix it?

Look very carefully at how the transactions are handled and how they
are setup in your application.

--
Best regards,
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)