with Table1 do
   begin
   TableType := ttParadox;
   TableName := 'test';
   DatabaseName := 'c:\temp';
  {set table structure}
   with FieldDefs do
    begin
       Clear;
         Add('ID',ftAutoInc,0,False);
         Add('Field1',ftString,4,False);
     end;
   with IndexDefs do
    begin
     Clear;
         Add('','ID',[ixPrimary]);
         Add('Filed1Indx','Field1',[]);
    end;
     {and create the table fails!!}
     CreateTable;
   end;

Please help me to understand what is going on?
I use Paradox supplied with Delphi5.
It doesn't support case-sensitive indexes or I am missing something?

Thanks in advance,
John

Sometimes the best way to understand how the BDE works with the
indexes and what it will support is to first interactively create
that index in Database Desktop, and look for error messages, if
any.

In this case, I think it's because single-field, case-sensitive
indexes have a reserved name, which is identical to the field
name.

Rick Carter
Rick.Car...@cincww.rcc.org
Chair, Paradox/Delphi SIG, Cincinnati PC Users Group