Reported By: Elevate Software Reported On: 1/20/2002 For: Version 3.03 Build 1
# 999Adding and then Deleting the Same Index Twice with AddIndex and DeleteIndex Causes #9217 Read Error I get a 9217 error when I try "addindex" a second time. The following code shows how. The first time, it's ok, then second time, error 9217 when addindex , repair utility finds errors effectively I have tested with 2 tables completely different, it's the same.
with thetable do
begin
close;
exclusive := true;
open;
addindex('verif', 'cat;key', [ixUnique]);
indexname := 'verif';
showmessage('between add and delete');
indexname := '';
deleteindex('verif');
close;
exclusive := false;
open;
end;
ResolutionFixed Problem on 1/21/2002 in version 3.04 build 1