>>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
delete tag all
=requery()
index on field2 tag field2
begin transaction
Gregory