>In VFP 6.0 help file the ALTER TABLE command says:
>
>ADD PRIMARY KEY eExpression3 TAG TagName2 [FOR lExpression4]
>
>But if I try to write something like this:(just a sample)
>
>ALTER TABLE 'TABLE1' ADD PRIMARY KEY cust_id TAG cust_id FOR !DELETED()
>
>VPP returns sintax error.
>
>Does someone know why ? or its a error in VFP help file.
>
>If I alter the table with the VFP GUI it works fine ! why it doesnt work if I try programatically ?
>
>TIA
>Peter Wagner

Don't put quotes around the table name. Note also that this index will not be used by Rushmore because of the FOR condition.