I have a program which creates a Paradox table at runtime.  It has been
working fine but, when I add a few lines of code to create a secondary
index, I always get the EDBEngineError "invalid index/tag name" and the
table isn't created.  This is my code...

      with AddIndexDef do
      begin
        Name := 'proj';
        Fields := 'Project';
        Options := [];
      end;

I have noticed that if I don't assign the name property, it works ok and the
index is automatically named "Project" but I need it to be named "proj".
Any ideas why this might be happening and how I can get round it?

Thanks a lot
Kate

I would use a query to create the index

with Query do
begin
  SQL.Clear;
  SQL.Add('create index project on your_table_name(project)'),
  ExecSQL;
end;

--
Bill (TeamB)
(TeamB cannot respond to questions received via email)