>Hi all,
>
>I just upgraded an application from VFP 7 to VFP 9 in a customer.
>So, I created a new index for each table:
>
>Index on Deleted() Tag DeletedTag Binary
>
>This index has collate as MACHINE. My others indexes (like name, for example) have collate as GENERAL.
>
>So I have a problem:
>
>If I have two collates in my indexes, how can I set the right collate to use rushmore optimization?
>
>Any idea?
>
>By now, I just deleted this index and it works great - but I want moreeeeeeee! ;-)
>
>TIA
An not character index, it doesn't have collate.
However this index is useless,
you add
FOR NOT DELETED()
to the primary index.