Subject | "lock conflict on no wait transaction deadlock" |
---|---|
Author | tickerboo2002 <support@tickerboo.com> |
Post date | 2003-02-21T14:54:14Z |
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
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