I'm having a problem dealing with a 3rd-party app that is connecting to my
database via ODBC (using the windows connector).
This software (UPS Worldship) creates shipment rows and sends INSERT commands
on one table. This table has a primary key that should be unique. Each row in
the table has
If there is a way for you to capture INSERT commands and convert them to
REPLACE commands, you'll have your solution.
- Original Message -
From: css [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Tuesday, June 20, 2006 6:44 PM
Subject: Duplicate Key problem (UPS software)
I'm
On Tue, 20 Jun 2006, css wrote:
} When someone voids a shipment in the UPS software, it sends another
} INSERT to the database, with the same data as the original row, the only
} difference being the void column is now Y;
}
} This of course doesn't work because Duplicate entry 'BLAHBLAH' for