DELETE FROM "MBUCFPRENAME" WHERE (("PRENAME_CODE" = :Original_PRENAME_CODE)) INSERT INTO "MBUCFPRENAME" ("PRENAME_CODE", "PRENAME_DESC", "PRENAME_SHORT", "SEX") VALUES (:PRENAME_CODE, :PRENAME_DESC, :PRENAME_SHORT, :SEX) select * from mbucfprename UPDATE "MBUCFPRENAME" SET "PRENAME_CODE" = :PRENAME_CODE, "PRENAME_DESC" = :PRENAME_DESC, "PRENAME_SHORT" = :PRENAME_SHORT, "SEX" = :SEX WHERE (("PRENAME_CODE" = :Original_PRENAME_CODE))