if you are running a query that inserts a new set of records in a table from other one, t开发者_开发技巧here is a way to force the update of the coincident pk record in the destination table, without deleting records or split the process in two others (insert new and update existing)?
In Firebird 2.1, you can do Update or Insert
UPDATE OR INSERT INTO T1 (F1, F2)
VALUES (:F1, :F2)
MATCHING (F1);
精彩评论