Brad, Maybee you have some corruption in your database causing the problem??? You might want to run autochck and reload your database.
Troy -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Brad Davidson Sent: Wednesday, July 16, 2003 1:35 PM To: RBASE-L Mailing List 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 > > > > > >
