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
