DELETE FROM "MBUCFPROVINCE" WHERE (("PROVINCE_CODE" = :Original_PROVINCE_CODE)) INSERT INTO "MBUCFPROVINCE" ("PROVINCE_CODE", "PROVINCE_DESC") VALUES (:PROVINCE_CODE, :PROVINCE_DESC) select * from mbucfprovince UPDATE "MBUCFPROVINCE" SET "PROVINCE_CODE" = :PROVINCE_CODE, "PROVINCE_DESC" = :PROVINCE_DESC WHERE (("PROVINCE_CODE" = :Original_PROVINCE_CODE))