Strange error using Delphi and Access Database
I Updated multiple records within one process, changing indexes to make the process faster. On my next run of the same routine, I got the following error:
Row handles must all be released before new ones can be obtained
A quick solution was deactivating the table first.
Example:
with ADOTable2 do begin
Active := False;
Active := True;
IndexName := 'PrimaryKey';
...
...
// later I'll change the index to fast record location, but after that Seek, I need to return to PrimaryKey
end;
Daniel
0 Comments:
Post a Comment
<< Home