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
