FOREIGN key means it references another table.

Try INDEX ON UPPER(Email) TAG EMail




>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