tdbf index oddity
Original Reporter info from Mantis: Old Dog
-
Reporter name:
Original Reporter info from Mantis: Old Dog
- Reporter name:
Description:
I have a database of states with two indexes, abbreviation and name. when the active index is name the records numbers are sequential. when the active index is name the record numbers skip.
[code]procedure TFormStates.CreateStatesTable(AFileName : String);
begin
With DbfStates do
begin
Close;
with FieldDefs do
begin
Clear;
Add('Abrev',ftString,2);
Add('Name',ftString,25);
Add('Country',ftString,6);
Add('Neighbors',ftString,80);
end;
TableName:=aFileName;
CreateTable;
Exclusive := true;
Open;
AddIndex('ndxAbrev', 'Abrev', []);
AddIndex('ndxName', 'Country + Name', []);
end;
MessageDlg('File created',mtWarning,[mbOK],0);
end;
[/code]
I have tried regenerating the indexes, deleting the index file and re-adding the indexes, and copying the data into a new file. Same problem.
Mantis conversion info:
- Mantis ID: 18789