Also check that your re-named column does not exist in the second table - but is not shown on the form - without your having realised it. It might be a long shot but these things often are...
Regards, Alastair. ----- Original Message ----- From: "Brad Davidson" <[EMAIL PROTECTED]> To: "RBASE-L Mailing List" <[EMAIL PROTECTED]> Sent: Wednesday, July 16, 2003 8:34 PM Subject: [RBASE-L] - Re: Redefining column when column exists in multiple tables > Thanks Troy for your reply - am repeating process with NOCHECK option. No other > columns renamed. Will report results - thanks again! > > Brad > > Troy Sosamon wrote: > > > A couple of things happen when you rename columns. > > > > If you do not use the nocheck option, R:base will go and modify your forms > > and reports to reflect the new name. Now you have you are going to have a > > relationship problem between the 2 tables because the form gets modified and > > the fields are no longer named the same. In theory when you do the second > > rename, it should fix the relationship problem in the forms. > > > > If you use the nocheck option, R:base does not modify your forms and > > reports, so when you do the second rename, everything will be like new w/o > > R:base messing with your forms at all. > > > > My guess is that this option may have been used inconsistenly during the > > renaming process, or you found a bug relative to form table relationships > > and renaming columns. I don't know that it would really be a bug because if > > you used the NOCHECK option, this would not be an issue. > > > > Double check your tables and make sure the column names and definitions are > > the same in both tables. > > > > You might need to go in and modify the form and save it again to get the > > tables linked. > > > > Another thing R:base does in forms is automatically link ALL fields between > > tables in the form with fields of the same name. Did you change the names > > of anything else when you were making these changes? > > > > Troy > > > > -----Original Message----- > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Brad > > Davidson > > Sent: Wednesday, July 16, 2003 1:00 PM > > To: RBASE-L Mailing List > > Subject: [RBASE-L] - Re: Redefining column when column exists in > > multiple tables > > > > 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 > > > > > > > > >
