Justin Wu wrote:
It will be always get 'database table is locked' message when trying to delete a record after select.
You are not deleting after select - you are deleting while still performing select. You can't do a write operation in the middle of a read. You have to select, remember the rows to be deleted later, reset or finalize your select statement, and then perform all deletes.
Igor Tandetnik