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