Subject "lock conflict on no wait transaction deadlock"
Author tickerboo2002 <support@tickerboo.com>
I've been working on this for the past 3 hours and I'm going round in
circles.

1. I have a TListView displaying records, populated by a cursor.

2. I add a new record via a dialog.

3. The TListView form tries to display this new record but gets the
above lock conflict.

4. Thereafter, whenever I try to populate the TListView I get the
above lock conflict.

I've used the TIB_MonitorDialog to confirm that the dialog is
correctly commiting the new record and I can see the record(s) in
Interbase Workshop.

I've performed a few sweeps on the database and even rebooted the
machine (it's a local db using 'localhost') but I still get the above
error when trying to populate the TListView.

After a reboot, simply trying to get the contents of the table causes
the conflict. I call cursor->First() and pow! conflict.

Any pointers to what I can try?

TIA

David