Thanks Razzak. I had forgotten to do the unload after the conversion. I found some bad column names. I have unloaded Structure separate from data and will be tracing the inpur of the Structure file to see what other problems I might have. I've been spending most of my time converting all the old style code, ie, set pointer to Declare Cursor, change to update, etc. The convert of forms and reports went quite well. I have some tweeking to do on the reports as the client is mostly using dot matrix printers and doesn't want to step up to all lasers.
Onward and Upward. Ron On Fri, Jan 3, 2014 at 8:46 PM, A. Razzak Memon <[email protected]> wrote: > 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! > -- > > >
