At 04:54 PM 1/3/2014, Ronald C Peterson wrote:
I am converting a 6.5++ database to 9.5 32 bit and the rules are not converting properly. A 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, FWIW ... When converting a legacy database, all rules (SYS_RULES) as well as all constraints (SYS_CONSTRAINTS), such as NOT NULL, UNIQUE, PK, and FK are also converted, if already defined. Use the following commands at the R> prompt to list RULES and CONSTRAINTS: LIST RULES FOR tablename CONSTRAINTS FOR tablename Then, take a close look and see what you find. Further, use the RBDefine (Data Designer) to review "Rules" for a detailed illustration. Also take note and recall if you have renamed any table or column that affects the execution of RULES. Last but not least, check the CHARACTER settings of your CONNected database and set the IDQUOTES to "`", if NULL. Feel free to reach out to me with further questions. Very Best R:egards, Razzak. www.rbase.com www.facebook.com/rbase -- 31 years of continuous innovation! 16 Years of R:BASE Technologies, Inc. making R:BASE what it is today! --
