>Hi Doug,
>
>>Sometimes FoxPro creates a temporary index after attempting to use what's already there but I don't know for sure.
>
>Yes, the SQL engine does this especially for JOIN conditions. That's one reason why SET COLLATE is causing so much trouble. *g*
>
>Christof
Hi Christof,
When >L< showed it to me many moons ago I was quite surprised. As far as the SET COLLATE stuff goes I'll continue on in my US-centric blissful ignorance. *bg*
Best,
DD
Best,
DD
A man is no fool who gives up that which he cannot keep for that which he cannot lose.
Everything I don't understand must be easy!
The difficulty of any task is measured by the capacity of the agent performing the work.