OI from RevG (OpenInsight 32-Bit)
At 24 JUN 2006 02:50:28PM Richard Richter wrote:
OK. I'm finally breaking down and trying to update RevG2B to OI 7.1. I had ARev 1.1 installed on the computer with Rev G2B and with OI 7.1. I transferred the files from RevG2B to Arev 1.1. Everything was fine. I opened OI7.1 and attached the ARev files. As soon as I tried to open the files in Table Builder, it bounced to the Debugger with an Fatal Runtime Error: "SYS1002: The opject code is invalid."
What am I doing wrong and ow can I correct it?
Thanks,
Richard Richter
At 24 JUN 2006 05:14PM [url=http://www.sprezzatura.com]The Sprezzatura Group[/url] wrote:
AREV 1.1 files have a different dictionary layout than AREV 3.12 so the object code is in a different place. Bottom line OI and AREV 1.1 don't mix. There are ways around this in fact with a little work it should be possible to get OI to read ROS files (although LNK will be more of a problem). We did this once as a proof of concept but regretfully our notes are lost in the sands of time.
World leaders in all things RevSoft
At 24 JUN 2006 06:03PM Richard Richter wrote:
I always thought the two programs had the same file format and could share data files between them. What did I miss?
At 24 JUN 2006 06:50PM [url=http://www.sprezzatura.com]The Sprezzatura Group[/url] wrote:
OI has only ever officially been compatible with AREV at the 3.12 level. The data is compatible, the dictionaries and ! code are not.
World leaders in all things RevSoft
At 24 JUN 2006 07:39PM Richard Richter wrote:
So what do I have to do to access the data from OI?
Richard
At 24 JUN 2006 08:16PM dsig@sigafoos.org wrote:
I would create a new table, set an alias to the old table then read in the dicts and build a new dict record with first 10-12 fields (see dict_equates) and then write to dict of new table. dict.mfs should take care of the rest.
Then just copy over the data.
Could be pretty automated ..
At 26 JUN 2006 11:33AM Sean FitzSimons wrote:
Richard,
If you upgrade to Arev 3.1.2, you will be able to read the data.
Sean
At 27 JUN 2006 09:29AM Bob Carten wrote:
In theory, To copy from RevG ROS files I believe that you can copy $RTP59 from arev to OI, create a record in SYSPTRS that looks like
VOLUME
RTP59
c:\MYDATA
then copy data in. However, given that dots cannot be in filenames, dicts have a different format, most data is in LNK files, etc. In practice I usually use Arev as a bridge, as recommended by Sean, or write an export routine in revg to OSBwrite my records to and dicts to flat files, read dicts in per DSig's rules, also making sure to convert dots to underscores in table names, column names, formulas which reference columns or tables. The Arev Upgrade routines can do much of the work for you.