Dick, 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. I frequently rearrange the SEC table to keep certain column names grouped together.
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 on the client's DB. 5) Append the backup table to the new table that includes the columns that you added. 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 -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Dick Fey Sent: Wednesday, April 28, 2010 10:11 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Project command I woud like to rearrange the columns in a 70 column table. Is it possible to do a project command using column numbers instead of names? Could not find anything about it in the docs. Dick Fey Carpet Broker Inc.
