is there something like INSERT UPDATE DUPLICATES, which does _not_ replace the whole row, but only updates the given fields?
i want to execute something like
INSERT table(key, field) VALUES(1, 'text')
if that fails, because of a key-collision, i should perform something like
UPDATE table(field) VALUES('text') WHERE key=1
is this possible somehow with one statement?
No, such a feature is not available. There is only the straight-forward-way
INSERT --> if duplicate key then UPDATE
just to explain myself: the problem that i have with UPDATE DUPLICATES is, that the row isn't updated (like an update-statement does), but replaced with a new row (like doing a DELETE and than doing the INSERT).
_______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
