>>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.

Fabio,

From VFP 9 Help, "If you use a FOR clause in the INDEX command, Rushmore cannot use the index for optimization." So, wouldn't that index be even more useless?

Regards,
Jim