Even though Razzak and Bill and others get credit for the right answer I will sleep better tonight knowing I helped in a small way. It makes me feel warn and fuzzy to know my lack of knowledge help enlighten someone else...LOL
Marc From: Dennis McGrath Sent: Tuesday, April 06, 2010 1:01 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Insert column LOL! There always seems to be an easier way. -------------------------------------------------------------------------------- From: [email protected] [mailto:[email protected]] On Behalf Of Emmitt Dove Sent: Tuesday, April 06, 2010 12:36 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Insert column [slapping self on forehead] Dang, that's a whole lot easier than what I've been doing when I want to add columns prior to my RBSynchronizer columns . 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 Bill Downall Sent: Tuesday, April 06, 2010 12:28 To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Insert column Marc, The answer is almost never No, but sometimes Yes gets really complicated. 1) Backup your database. 2) SET MULTI OFF 3) CONNECT database 4) ALTER TABLE tablename ADD COLA datatype etc ALTER TABLE tablename ADD COLB datatype etc ALTER TABLE tablename ADD COLC datatype etc PROJECT tableX FROM tablename USING Co1, Col2, ColA, ColB, ColC, Col3, Col4, Col5 -- drop any constraints from tablename here DROP TABLE tablename RENAME TABLE tablex TO tablename -- use ALTER, CREATE, and RULES commands to create constraints, -- rules, and indexes on tablename Bill On Tue, Apr 6, 2010 at 12:12 PM, MDRD <[email protected]> wrote: 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
