>>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.
Even then you get a syntax error. It seems there is something it doesn't like about the "FOR !DELETED()" portion of the command. Strange, I got the command to run w/o that clause but not with it.
Bill
William A. Caton III
Software Engineer
MAXIMUS
Atlanta, Ga.