Jordan,
Thre're a couple of problems with your INDEX command.
1. Don't use alias in index expression. That's what causes error message.
2. VFP supports fixed lenght index expressions. Using ALLTRIM() function could cause truncation of the field value.
use (cd_l + "compdtl") EXCLUSIVE
index on upper(cins_claimnum) tag CINS_CLAIM additive
>Hi all,
>i am having trouble with adding an index to an existing table that already has indexes (.cdx) associated with it. This is the code i use:
>
>use cd_l + "compdtl"
>index on upper(alltrim(compdtl.cins_claimnum)) tag CINS_CLAIM additive
>
>i get no errors when i execute this code, however, when i run a
>
>OPEN DATA wimsmain validate
>
>i get the error: ALIAS "compdtl" is not found. i have also tried to use the OF cdxFileName option to no avail. am i doing something wrong to add this index to this table?
>
>
--sb--