Thanks Buddy I think APPEND is working, it is hard to tell with over 300 rows to check.
Marc ----- Original Message ----- From: "Walker, Buddy" <[EMAIL PROTECTED]> To: "RBG7-L Mailing List" <[email protected]> Sent: Wednesday, June 29, 2005 8:56 AM Subject: [RBG7-L] - RE: Insert Marc project a temporary table from the table, then load the temp table and then append temptable to main. R:>PROJECT TEMPORARY TmpNewTable FROM GoodTable USI ALL WHE COUNT = 0 R:>LOAD TmpNewTable FROM whateverfile...... R:>APPEND TmpNewTable TO GoodTable Buddy -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Marc Sent: Wednesday, June 29, 2005 9:39 AM To: RBG7-L Mailing List Subject: [RBG7-L] - Insert Hi I want to insert several hundred rows of data into a table for my users. The problem is some of them already have some of these rows of data and when the insert command tries to add a row that already exists I get an error and the process stops. *there is a unique rule on the main column So, is there a better way to "insert" these rows into their table and have it ignore the duplicate rows but keep processing the rest of the rows of data? Thanks Marc
