Alastair, David - Have performed such column size changes in order without incident, until today! Other than dropping and re-creating indexes for the column in 5 of 12 tables (remaining tables subject column not indexed), there's no change to the procedure submited. HOWEVER, I have a 2 table form in RBase 6.5++ for DOS that isn't working correctly, and heck if I can find out why.
After changing column size for column (PN) per above, then going to form INV, clearing, then re-placing resized field in master table (INV), then exiting, saving and entering form via application program, all related data from bottom, slave table (POLINE) is missing. There are no eeps to the revised field (PN) and nothing else revised in form. Yes, field order has been re-set to original. Other than simply 'stretching' the size of column PN from 20 to 23 - no other changes have been made, yet the loss of related data in slave table. Common column to both tables IS (PN). Any suggestions on what I'm not doing right is appreciated - TIA! Brad Davidson "David M. Blocker" wrote: > CHeryl > > Lets say you want to redefine MyCol TEXT 6 to MyCol TEXT 12 > > Lets say it appears in tables DAVID and CHERYL > > Let's say it appears in the computed column MyCompCol in both tables as > MyCompCol=(MyCol&LastName) TEXT 20 > > Here are the steps: > > AUTOCHK the database and back it up > > -- Remove computed column definition temporarily in > --CHERYL > ALTER TABLE CHERYL ALTER COLUMN MyCompCol TO MyCompCol TEXT 20 > > --Temp rename MyCol to MyCol1 and change size in > --CHERYL > ALTER TABLE CHERYL ALTER COLUMN MyCol TO MyCol1 TEXT 12 > > -- Remove computed column definition temporarily in > --DAVID > ALTER TABLE DAVID ALTER COLUMN MyCompCol TO MyCompCol TEXT 20 > > --Do the permanent redefine in DAVID > ALTER TABLE DAVID ALTER COLUMN MyCol TO MyCol TEXT 12 > > -- Put back computed col definition in DAVID > ALTER TABLE DAVID ALTER COLUMN MyCompCol to MyCompCol=(MyCol&LastName) TEXT > 20 > > --Rename back to original name in CHERYL > ALTER TABLE CHERYL ALTER COLUMN MyCol1 TO MyCol TEXT 12 > > --Put back computed col definition in CHERYL > ALTER TABLE CHERYL ALTER COLUMN MyCompCol to MyCompCol=(MyCol&LastName) TEXT > 20 > > Now you'll need to PACK the database, check it again and back it up. > > David Blocker > > ----- Original Message ----- > From: "McClure, Cheryl" <[EMAIL PROTECTED]> > To: "RBASE-L Mailing List" <[EMAIL PROTECTED]> > Sent: Wednesday, July 16, 2003 12:51 PM > Subject: [RBASE-L] - Redefining column when column exists in multiple tables > > > 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 > > > >
