>>Could you restrict the sort capability to the columns where sorting makes sense ?
>Yes, I can do that. I have an interface for that on my grid class. I do it if necessary.
>But I'm lazy. If ever possible,I use a computer to work for me, not I work for the computer. <s>
>
>>Or perhaps just keep one index that is currently used.
>
>>&& requery
>>&& save tag info
>>delete tag all
>>=requery()
>
>As I mentioned before ,recreate does not work (I've testet at the point where i create the index)
>
>I will look at Vlads advice, but it seems, that it will result in restriction. (I don't creep through all transactions. Oh no!)
>
>Agnes

Agnes,

Maybe Vlad's solution is better, do not know

but this works, have tested it

before the requery() , delete the tags, requery(), recreate tag

best with only one index

&& requery
&& save tag info
delete tag all
=requery()
&& recreate the one and only index if necessary
&& does not take too much additional time compared to the requery
index on field2 tag field2

begin transaction && works