Thank you for your lightning fast response!

I tried your suggestion but the index is not in the the DBC. Insted I get an error message saying the the index definition for the indexname EMAIL in the CDX could not be found in the database. I can add it as on option in the error message. But I would like to prevent this message as I try to do an update routine for customers with an older version of my app.

Any other idea?

TIA
Gerhard

>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