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
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer