I have a table created with row level locking. This table is being used by a external system (ODBC), which does SELECT * FROM Table and after succesfull processing of the data does a delete of the data with DELETE FROM Table WHERE ID <= X where X is equal to the largest ID returned from the previous select.
The problem is that the application feeding this table ocasionally fails on insert due to locking problems. I would claim that neither the select or delete would create an exclusive lock that would prevent inserts or am I wrong ?
All I have is my ISAM error. Any ideas how to identify the failing SQL statement ?