Hello,

I want to add an index defintion to a DBC programatically. The index is not a primary key, not a cadidate key and not a foreign key. It has no reference to another table.

I tried

ALTER TABLE (lcDataPfad + "DPERS.DBF") ADD FOREIGN KEY UPPER(EMAIL) TAG EMAIL

But that gives an syntax error for the REFERENCE clause is missing.

How do I add the index definition to the database?

TIA
Gerhard