What is the recommended procedure for moving data tables where table and column names both contain dots, from Arev 3.12, retaining indexes if possible and minimizing code conversion?

If I convert and tell the wizard not to change dots to underscores, the ! tables are not built, but the dicts retain the indexing information. If I tell it to change dots to underscores, indexes get build but much code that is looking for dots fails to work. (In both cases specifying that indexes should be rebuilt).

What should I be seeing when dots are not converted? Shouldn't I be able to access both table and column names with either dots or underscores (from Arev32), both in RBasic code and from TCL?

Thanks,

David

As a follow up–I am getting a lot of windows abending on read with a "No Table for Sysobj RTP27." My guess is that this is related to dot/underscore issues. Is there a way to find out what table RTP27 is trying to load?

Thanks.

David, for AREV32 to work you must convert the dots to underscores or the tables can not be attached and the dictionaries can not be referenced. The AREV32 system will recognize yor dots but the actual table must have an underscore for both tables and dictionaries. If you try to build an index during the conversion that is referencing programs it will probably blow up since the programs are not yet compiled yet and will only work in the OI environment. If this is the case than you should probably build the index in arev32.

The rtp27 is saying can not find the object code and unfortunately does not necessarily tell you which program. You will need to debug the offending process. Make sure you have compiled all the programs in the conversion and fixed all the errors.

View this thread on the Works forum...