DELETE FROM "MBUCFMEMBGROUP" WHERE (("COOP_ID" = :Original_COOP_ID) AND ("MEMBGROUP_CODE" = :Original_MEMBGROUP_CODE) AND ("MEMBGROUP_CONTROL" = :Original_MEMBGROUP_CONTROL)) INSERT INTO "MBUCFMEMBGROUP" ("COOP_ID", "MEMBGROUP_CODE", "MEMBGROUP_CONTROL", "MEMBGROUP_DESC", "MEMBGROUP_AGENTGRG", "ADDR_NO", "ADDR_MOO", "ADDR_SOI", "ADDR_ROAD", "ADDR_TAMBOL", "ADDR_AMPHUR", "ADDR_PROVINCE", "ADDR_POSTCODE", "ADDR_PHONE", "ADDR_FAX", "MBGRPSECT_CODE", "SAVEDISK_TYPE", "MEMBGROUP_LEVEL", "MEMBGROUP_ORDER", "MEMBGRPTYPE_CODE", "PRINTRECEIPTADDR_TYPE", "MANAGER_GROUP", "MEMBGROUP_SECTION", "COOPBRANCH_ID") VALUES (:COOP_ID, :MEMBGROUP_CODE, :MEMBGROUP_CONTROL, :MEMBGROUP_DESC, :MEMBGROUP_AGENTGRG, :ADDR_NO, :ADDR_MOO, :ADDR_SOI, :ADDR_ROAD, :ADDR_TAMBOL, :ADDR_AMPHUR, :ADDR_PROVINCE, :ADDR_POSTCODE, :ADDR_PHONE, :ADDR_FAX, :MBGRPSECT_CODE, :SAVEDISK_TYPE, :MEMBGROUP_LEVEL, :MEMBGROUP_ORDER, :MEMBGRPTYPE_CODE, :PRINTRECEIPTADDR_TYPE, :MANAGER_GROUP, :MEMBGROUP_SECTION, :COOPBRANCH_ID) select * from mbucfmembgroup UPDATE "MBUCFMEMBGROUP" SET "COOP_ID" = :COOP_ID, "MEMBGROUP_CODE" = :MEMBGROUP_CODE, "MEMBGROUP_CONTROL" = :MEMBGROUP_CONTROL, "MEMBGROUP_DESC" = :MEMBGROUP_DESC, "MEMBGROUP_AGENTGRG" = :MEMBGROUP_AGENTGRG, "ADDR_NO" = :ADDR_NO, "ADDR_MOO" = :ADDR_MOO, "ADDR_SOI" = :ADDR_SOI, "ADDR_ROAD" = :ADDR_ROAD, "ADDR_TAMBOL" = :ADDR_TAMBOL, "ADDR_AMPHUR" = :ADDR_AMPHUR, "ADDR_PROVINCE" = :ADDR_PROVINCE, "ADDR_POSTCODE" = :ADDR_POSTCODE, "ADDR_PHONE" = :ADDR_PHONE, "ADDR_FAX" = :ADDR_FAX, "MBGRPSECT_CODE" = :MBGRPSECT_CODE, "SAVEDISK_TYPE" = :SAVEDISK_TYPE, "MEMBGROUP_LEVEL" = :MEMBGROUP_LEVEL, "MEMBGROUP_ORDER" = :MEMBGROUP_ORDER, "MEMBGRPTYPE_CODE" = :MEMBGRPTYPE_CODE, "PRINTRECEIPTADDR_TYPE" = :PRINTRECEIPTADDR_TYPE, "MANAGER_GROUP" = :MANAGER_GROUP, "MEMBGROUP_SECTION" = :MEMBGROUP_SECTION, "COOPBRANCH_ID" = :COOPBRANCH_ID WHERE (("COOP_ID" = :Original_COOP_ID) AND ("MEMBGROUP_CODE" = :Original_MEMBGROUP_CODE) AND ("MEMBGROUP_CONTROL" = :Original_MEMBGROUP_CONTROL))