>>>>fo all I remember it was
>>>>
>>>>INDEX ON fieldname2 TAG xyz OF CDX(1) ADDITIVE
>>>>
>>>>
>>>>edit:
>>>>
>>>>Cursordapter needs same solution.
>>>>INDEX ON creates a cdx based on dbf(). Every REQUERY() changes the dbf(), so the second INDEX ON will try to create a second cdx file
>>>
>>>That is because you have OF clause in INDEX ON ...
>>>
>>>INDEX ON fieldname2 TAG xyz
>>>
>>
>>Hi Borislav,
>>
>>the upper section with full code where the second INDEX ON after REQUERY is without
OF will not run.
>>Only the form with
OF will do there.
>
>
>My all CAs are indexed w/o OF and I never have problems after CursorRefresh().
Do you index after REQUERY?
Words are given to man to enable him to conceal his true feelings.
Charles Maurice de Talleyrand-Périgord
Weeks of programming can save you hours of planning.
OffThere is no place like [::1]