Hi Javier It is not the error message that is the problem but it seems that the insert command stops once it hits a row of data that violates the rule or PK. or am I missing something else?
Marc ----- Original Message ----- From: "Javier Valencia" <[EMAIL PROTECTED]> To: "RBG7-L Mailing List" <[email protected]> Sent: Wednesday, June 29, 2005 8:45 AM Subject: [RBG7-L] - RE: Insert > Marc: > I believe that if you: > SET MESSAGES OFF > SET ERROR MESSAGES OFF > The load will proceed without displaying the error codes. > Javier, > > Javier Valencia, PE > President > Valencia Technology Group, L.L.C. > 14315 S. Twilight Ln, Suite #14 > Olathe, Kansas 66062-4578 > Office (913)829-0888 > Fax (913)649-2904 > Cell (913)915-3137 > ================================================ > Attention: > The information contained in this message and or attachments is intended > only for the person or entity to which it is addressed and may contain > confidential and/or privileged material. Any review, retransmission, > dissemination or other use of, or taking of any action in reliance upon, > this information by persons or entities other than the intended recipient > is prohibited. If you received this in error, please contact the sender and > delete the material from all system and destroy all copies. > ====================================================== > > -----Original Message----- > From: [email protected] [mailto:[EMAIL PROTECTED] Behalf Of Marc > Sent: Wednesday, June 29, 2005 8: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 > >
