Windows Software | Windows Tips | IT Information

Details and tips found at job and experiences (Windows Software | Windows Tips | IT Information).

Sunday, October 07, 2007

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

Labels: , , ,

0 Comments:

Post a Comment

<< Home