DELETE FROM "STPRODUCTUNIT" WHERE (("UNIT_CODE" = :Original_UNIT_CODE) AND ("COMPANY_ID" = :Original_COMPANY_ID)) INSERT INTO "STPRODUCTUNIT" ("UNIT_CODE", "COMPANY_ID", "UNIT_DESC", "COOP_ID") VALUES (:UNIT_CODE, :COMPANY_ID, :UNIT_DESC, :COOP_ID) select * from stproductunit UPDATE "STPRODUCTUNIT" SET "UNIT_CODE" = :UNIT_CODE, "COMPANY_ID" = :COMPANY_ID, "UNIT_DESC" = :UNIT_DESC, "COOP_ID" = :COOP_ID WHERE (("UNIT_CODE" = :Original_UNIT_CODE) AND ("COMPANY_ID" = :Original_COMPANY_ID))