Thank you Albert for sharing this to confirm process I too use. Other than my issuing the option NOCHECK in rename command, this jives with what I do. However, in future, as precautionary (to preclude an EXISTING db corruption issue) I'll unload/reload the db prior to altering column definitions. Schema for my form was definitely corrupted, as autochk, rscope, unload/reload would not repair it, as no problems were found by these processes! Appreciate everyone's feedback on this.
-Brad Albert Berry wrote: > This is the procedure I use to change a column definition > > R>DISCONNNECT > R>SET MULTI OFF > R>CONNECT database > R>RENAME ColX TO ColY IN TableX > R>ALTER TABLE TableX ALTER COLUMN ColY ... > R>RBDEFINE > --In RBDEFINE, open each of the other tables, navigate to the column, > --rename it. You will see the definition change when you change the name > --to ColY. > --EXIT RBDEFINE > R>RENAME COLUMN ColY TO ColX > R>FORMS > --Open each form and Save it. You will see an error message that the system is > changing the column definition in the form. You will have to force the save - The > form will return to the original definition if you do not and exit the form. > (Perhaps in certain versions only, but ...) > R>REPORTS > -- As above > -- I recommend a reload at this point, because you now have twice the data space > used up for each of the tables. > -- Now you can let everyone else in > DISCONNECT > SET MULTI ON > > -- SET ALL DONE ON > "McClure, Cheryl" <[EMAIL PROTECTED]> wrote: > > >Running current Windows 6.5 version of R:BASE: I need to change a text > >column in a table from 6 characters to 12 characters. This column appears > >in more than one table and is used in a computed column. I know there is > >some sort of round robin type method to change the column, but the details > >have slipped my mind. Could someone refresh me please? > > > >Thanks! > > > >Cheryl McClure > >CDC > > > > > > -- > Albert Berry > Full Time Consultant to > PSD Solutions > 350 West Hubbard, Suite 210 > Chicago, IL 60610 > 312-828-9253 Ext. 32 > > __________________________________________________________________ > McAfee VirusScan Online from the Netscape Network. > Comprehensive protection for your entire computer. Get your free trial today! > http://channels.netscape.com/ns/computing/mcafee/index.jsp?promo=393397 > > Get AOL Instant Messenger 5.1 free of charge. Download Now! > http://aim.aol.com/aimnew/Aim/register.adp?promo=380455
