How to REPLACE a unique field?

From: Ramon F Herrera <ramon_at_conexus.net>
Date: 9 Mar 2004 15:31:57 -0800
Message-ID: <c9bc36ff.0403091531.69bfdcc4@posting.google.com>

(newbie and RTFM question, already tried Google, and wouldn't know in what manual page to begin searching, so bear with me)

I have a table with a unique field (employee ID). Currently, every time a given employee ID is already inserted, the next repeated one is rejected and I get a "constraint violated" in the log file. What I'd like to do is load the data in chronological order, and every time a repeteated ID comes along, it should _overwrite_ the previous one. That way, I will end up most the most up-to-date record.

In your answer, feel free to throw in different approaches to this problem, if there are multiple solutions!

TIA, -Ramon F. Herrera Received on Tue Mar 09 2004 - 17:31:57 CST