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
