Marc,
That's the way it is. Whenever you issue an ALTER TABLE command, R:BASE renames the table, makes the change then, in effect, projects the result into a new table. The original, renamed table is removed from the schema, but the space it consumed remains consumed until you do a PACK or RELOAD. Do a LIST and note where your table falls in the list. Now do an ALTER TABLE followed by another LIST. Unless your table was the last on the list to begin, it will be elsewhere in the list. That is a visual clue as to what is going on behind the scenes. Emmitt Dove Manager, Converting Applications Development Evergreen Packaging, Inc. [email protected] (203) 214-5683 m (203) 643-8022 o (203) 643-8086 f [email protected] From: [email protected] [mailto:[email protected]] On Behalf Of MDRD Sent: Wednesday, June 16, 2010 09:47 To: RBASE-L Mailing List Subject: [RBASE-L] - Re: RB2 files quadruples in size? Larry What a mess! Unfortunately this is a permanent table with over 13,000 rows. Such a simple change sure can cause major pains. Thanks for the tip Marc 3. If this is permanent, prexisting data, make a temporary table with different column names and the longer field sizes. Then append the data to the temporary table, delete the data from the real table, do the ALTERs, and append the data back from the temporary table to the real one. -- Larry _____ From: MDRD <[email protected]> To: RBASE-L Mailing List <[email protected]> Sent: Wed, June 16, 2010 8:48:30 AM Subject: [RBASE-L] - RB2 files quadruples in size? Hi The RB2 file went from about 200 megs to over 800 megs all of the sudden? It appears this block of code caused the problem, My only guess is to put a Pack Table every so often to keep from hitting this wall Thanks Marc -- there is only 300 rows in this table CREATE INDEX v1 ON `spbutton` (`NewButName` ASC ) CREATE INDEX v2 ON `spbutton` (`V2` ASC ) CREATE INDEX v3 ON `spbutton` (`V3` ASC ) CREATE INDEX v4 ON `spbutton` (`V4` ASC ) -- only 10-20 rows in this table the column was Text 50 ALTER TABLE PopTCS ALTER PopTCSTxt TO PopTCSTxt TEXT 150 -- only 13,337 rows in this table the Text fields were 50 each -- total row size after this is around 3021 ALTER TABLE travcard ALTER Sympt1 TO Sympt1 TEXT 150 ALTER TABLE travcard ALTER Sympt2 TO Sympt2 TEXT 150 ALTER TABLE travcard ALTER Sympt3 TO Sympt3 TEXT 150 ALTER TABLE travcard ALTER Sympt4 TO Sympt4 TEXT 150 ALTER TABLE travcard ALTER Sympt5 TO Sympt5 TEXT 150 ALTER TABLE travcard ALTER Therapy1 TO Therapy1 TEXT 150 ALTER TABLE travcard ALTER Therapy2 TO Therapy2 TEXT 150 ALTER TABLE travcard ALTER Therapy3 TO Therapy3 TEXT 150 ALTER TABLE travcard ALTER Therapy4 TO Therapy4 TEXT 150 ALTER TABLE travcard ALTER Therapy5 TO Therapy5 TEXT 150 ALTER TABLE travcard ALTER Adj1 TO Adj1 TEXT 150 ALTER TABLE travcard ALTER Adj2 TO Adj2 TEXT 150 ALTER TABLE travcard ALTER Adj3 TO Adj3 TEXT 150 ALTER TABLE travcard ALTER Adj4 TO Adj4 TEXT 150 ALTER TABLE travcard ALTER Adj5 TO Adj5 TEXT 150
