>I have a major search application in which I just put a new table in to store the clients that are linked to the appraisers. I made an index callled appclin which was str(appraiser_id) + str(client_id). I at first made this the primary index. I then realized because I am adding and subtracting appraiser_ids and client_ids that I was having problems with uniquiness of the index appclin being violated. I then changed the property on the index to be a regular index. Now every time I try use that table I get an error stating that I must rebuild the indicies. I've tried to validate the database, but it doesn't do much good.
>
>Is there any way to remedy this problem?
Just recreate the indexes from scratch. If you know all of the expressions, USE the table exclusively, issue a DELETE TAG ALL, and then reissue your index expressions. If there are a lot of indexes, and this will be a major PITA, download my GenTable utility here and use it to give you a code listing of all your index tags that you can use to recreate them.
Erik Moore
Clientelligence