>>>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().
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.