Thanks John That is sort of what I came up with after the help form everyone except I used Insert instead of Append.
Marc From: John Engwer Sent: Tuesday, April 06, 2010 3:05 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Insert column Marc, Here is how I accomplish the task when I am updating my security file for my vertical applications. Steps 1 & 2 are accomplished on the development system and steps 3 through 5 are done at the client location. Step-by-step 1) Insert the columns using designer ( on your development system) 2) Unload the structure for the table that you modified. 3) PROJECT a backup table of the clients original unmodified table. (creates backup table with original data) 4) Load the new modified structure. 5) Append the backup table to the new table that includes the added columns. Here is the snippet of code that I use. I have been using it for years and it has never failed. I just copy the structure file of the new table and the code below to the clients site and execute it. --update security table SEC DROP table SEC_BKU --SEC_BKU is the backup table PROJECT SEC_BKU FROM SEC USING * --SEC is the original table name RUN SEC.STR --Loads the new structure APPEND SEC_BKU TO SEC --Loads the original data into the new structure John From: [email protected] [mailto:[email protected]] On Behalf Of MDRD Sent: Tuesday, April 06, 2010 12:12 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Insert column Hi I think the answer is No but I will ask anyway. I want to insert 3 columns to the middle of a Table using a command file. I have Col1, Col2, Col3, Col4, Col5 and I want to insert ColA, ColB, ColC like this. Col1, Col2 ,ColA, ColB, ColC , Col3, Col4, Col5 Is that possible? Thanks Marc
