Unanswered: Error: Could not insert new row - duplicate value in a UNIQUE INDEX column
I'm trying to set up a script which loads an informix table that I will
use in my Access report.
I will be loading new customers into it based on transaction date. But
users can have more than one day's transaction, if I load a bunch of
people yesterday and a few of them also have a transaction today, I get
that error, and the processing stops even if most of today's customers
are not there already. How do I get Informix to just ignore the Index
Violation and then continue? What I want is one row per customer
during the current fiscal year which will be deleted at the start of
the new fiscal year and updated to 0 at the start of a new month.
The table that I'm loading customers into has fields for sales this
year, sales this month and yesterday's sales. I want to load new
customers, but if a customer is already in the table, I want it to add
yesterday to the fiscal year total and the fiscal month total.
Otherwise, getting the totals takes forever.
I think that you should revise the logic of the process and if finds an existing client, that rewrite the row instead of inserting it.
Or, change the process, and use temporary table before, then filter this rows.