>>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.
"However this index is useless"! This information is completely wrong!!! A binary index tag on deleted() can speed up your queries a lot, unlike orinary index tag on deleted() in previous versions of VFP. But I expect you to deny this statement. (Sigh in advance!)