Re: Reading Updating Inserting Indexed Table - Sequence of Events

[Phillip Ward]

Basically: Do whichever you would expect to work most often and add something to deal with the [few] cases where it doesn't.

If you would normally expect to insert new records, then do that - and catch the exception that's thrown when you get a duplicate row.

If you would normally expect to update existing rows, then do that - and check to make sure that a row was actually updated and, if not, insert a new one.

OK, there may be "cleverer" ways of doing this with the SQL syntax for particular DBMSs, but that's the basic principal.

Regards, Phill W.