Hi Chris,

I don't know if you've been told this, but. . .

I was reading the VFP 6 "Programmer's Guide" and found that one of the enhancements is the addition of the FOR clause in ALTER TABLE to permit the creation of filtered PRIMARY and FOREIGN keys.

So, while that concept may well be at odds with convention, at least VFP is now consistent in that we *can* now do it 'everywhere'.

Cheers,

JimN

>I am writing a program that re-indexes the tables in a database. First, the program delete all the tags ("delete tag all"). Then it issues "index on xxx tag yyy [for zzz] [descending] [candidate]". This works fine unless the tag needs to be a primary key. The "index on..." command doesn't seem to have a way to specify that the tag is to be the primary key. The only solution I've found is to use the command "alter table aaa add primary key bbb...". The problem with this approach is that it doesn't allow one to specify "descending" or a filter expression.
>
>How does one programmatically create a primary index tag that contains a filter or the "descending" clause?
>
>Thanks,
>Chris Lawrence