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
Gerhard Schmidbauer
URANUS Software GmbH