DELETE FROM "MBUCFMEMBTYPE" WHERE (("MEMBTYPE_CODE" = :Original_MEMBTYPE_CODE) AND ("COOP_ID" = :Original_COOP_ID)) INSERT INTO "MBUCFMEMBTYPE" ("MEMBTYPE_CODE", "MEMBTYPE_DESC", "COOP_ID") VALUES (:MEMBTYPE_CODE, :MEMBTYPE_DESC, :COOP_ID) SELECT MEMBTYPE_CODE, MEMBTYPE_DESC, COOP_ID FROM MBUCFMEMBTYPE UPDATE "MBUCFMEMBTYPE" SET "MEMBTYPE_CODE" = :MEMBTYPE_CODE, "MEMBTYPE_DESC" = :MEMBTYPE_DESC, "COOP_ID" = :COOP_ID WHERE (("MEMBTYPE_CODE" = :Original_MEMBTYPE_CODE) AND ("COOP_ID" = :Original_COOP_ID))