Re: How do I copy records?

In article <8gh1vc$24na$1@razor.dct.com>, "Kristi B" <kristi@kaytee.com> wrote: > I'm trying to copy all records where the first field is "001" back into the > table and changing that field to "075". So, I'll have a duplicate set of > records, except for the first field. > > I'm running 7.24.uc5, Baan IV (mgmt decision). > Here are my steps: > > select * from table > where column="001" > into temp temptable;> > drop index on table> > insert into table select "075", ?? from temptable> > index table > > (The ?? is where I get stuck. How do I insert the rest of the columns? Do I > have to type them all one by one? AND Baan uses hash columns, so the second > set of data won't insert back into table because sql says there are > duplicate values. What do I do with these hashes?) > > help. > You try this? select * from table where column = '001' into temp temptable; update temptable set column = '075'; insert into table select * from temptable; > -- # unrm / ksh: unrm: not found # man cpio Sent via Deja.com http://www.deja.com/ Before you buy.