An application that I am bringing from Revelation 1.16 to 3.12 (which I inherited) has all of the tables, in multiple directories, with multiple application subdirectories, all as being owned by the SYSPROG application. I have managed to create new 3.12 applications for the menus, popups, etc., and copy the rows out of the old tables to the new application tables. The problem now, is that the old data tables are still owned by the SYSPROG application instead of the new application name. Is there any way to easily change the application association of the tables. I have tried RENAMETABLE, but it immediately gets upset about relational indexes and not being able to find other tables (due to application linkages, etc). I'm thinking that the best bet may be COPYTABLE. Is there an easier way? There are hundreds of these files.

The problem is that the application is hard coded into the indexing logic so…. we'd setfile to the revmedia files, modify the entries for the files to reflect the new application, delete all the ! code and recompile the index transaction logic.

Is this sufficient detail for your purposes?

The Sprezzatura Group

[i]Celebrate CeBIT with Sprezz Local![/i]

If the Spress answer is not sufficient, I'm not sure that you really want to try it. Another, albeit tedious, method is to print out out all the indexes for each file (listindex) and then remove all the indexes. Reset the application using renametable and then recreate all the indexes.

If you want to try editing the revmedia files, make sure you have at least two verified backups.

Thanks for your help. The editing of the revmedia table seems to have been the best solution for me. The setalias trick to allow access to the otherwise inaccessable table was what I needed.

View this thread on the forum...