It seems a lot of my indexes are corrupted and I'm trying to delete them and add new ones. I get an error "ENG0010 - F.Distributor line 3. Variable has not been assigned a value" when I try and rebuild several of my indicies. However I can't create a new index because the account in which the tables were originally created under arev is different than my new account in OpenInsight. I would have used the same name but I am limited to 8 characters now and the old account name had 10.

My question is how do you change the account name for the tables? I've tried copying the old arev tables to my OI directory changing the the first two numbers of the ".lk" and ".ov" files to the same numbers as the tables created in OI but this did not work. The tables were listed in the database manager but had no attributes defined for them.

I also don't know why I can't create indicies for tables in a different account. OI lets me do anything else to them such as changing a data type for a field or even deleting a field.

Thanks.

Hi Greg,

To create a permanent alias for another account:

1. run attach_table "", "REVMEDIA"

2. run copy_row "REVMEDIA", "*[list=1]", "", "*"

(Repeat #2 for the dictionary and index too)

3. run detach_table "REVMEDIA"

4. run attach_table "", ""

I haven't tried this for the purpose of index maintenance but it should work.

Cameron Purdy

Revelation Software

The account name in the !FILE record in the !FILE will need to be updated with the new account name and the ! record will have to be regenerated by deleting the existing one and detaching and reattching the data file.

[email protected]

Sprezzatura, Inc.

Thanks for the help. I got it converted. That helped me a lot!

View this thread on the forum...