My bad. I hadn't read far enough in the Conversion Guide. I failed to do the Unload and Reload after the Convert command. They are coming in fine now along with all the comments, etc.
Sorry to have taken your time for my foolish error. Ron On Fri, Jan 3, 2014 at 7:06 PM, James Bentley <[email protected]>wrote: > Ronald, > Even though you could unload in v6.5++ the rules table and reload in v9.5 > this may not correct the problem. > Note the definition the rules table: > Table: SYS_RULES No Lock(s) > > No. Column Name Attributes > --- ------------------ > ------------------------------------------------------ > 1 SYS_TABLE_ID Type : INTEGER > Index : SINGLE-COLUMN > 2 SYS_MESSAGE Type : NOTE > 3 SYS_FLAGS Type : INTEGER > 4 SYS_WHERE Type : NOTE > 5 SYS_RULE_ID Type : INTEGER > 6 SYS_COLUMN_NUM Type : INTEGER > > only columns 1 thru 4 are used. column 5 and 6 are not presently used by > any version. > > Your problem seems to be that the SYS_TABLE_ID (COLUMN 1 which links to the > SYS_TABLE_ID in SYS_TABLES to provide the table name. The actual rule > statements are > found in SYS_WHERE (Column 4). There appears to be a mismatch between the > table name > identified in column 1 and the rule defined in column 4. > > In version 6.5++ if you do a "LIST RULES" at the "R>" prompt you should > be able to verify that the column 1 table name matches the column 4 rules. > This will > help you identify if there are 6.5++ problems. > > In version 9.5 you do the same "LIST RULES" and match to the 6.5++ list. > If there are differences you should open a problem with RDCC. As there is > a conversion problem. > > An alternative is for each mismatch browse the SYS_TABLE for the correct > SYS_TABLE_ID and > edit the SYS_RULES table and correct the column 1 SYS_TABLE_ID. > > Or as an alternative delete and recreate the improper rules. > > Jim Bentley, > American Celiac Society > 1-504-737-3293 > > ------------------------------ > *From:* Ronald C Peterson <[email protected]> > *To:* RBASE-L Mailing List <[email protected]> > *Sent:* Friday, January 3, 2014 3:54 PM > *Subject:* [RBASE-L] - Converting Rules > > I am converting a 6.5++ database to 9.5 32 bit and the rules are not > converting properly. The tables referenced in the 9.5 rules are not > correct. Can I unload the sys_rules table from the 6.5 version and then > reload them into the 9.5 after deleting the improperly converted ones? > Ron Peterson > > >
