DELETE FROM "CMCOOPMASTER" WHERE (("COOP_ID" = :Original_COOP_ID)) INSERT INTO "CMCOOPMASTER" ("COOP_ID", "COOP_NAME", "COOP_CONTROL", "COOP_SUBTYPE", "ADDR_NO", "ADDR_MOO", "ADDR_ROAD", "ADDR_TAMBOL", "ADDR_AMPHUR", "ADDR_PROVINCE", "ADDR_POSTCODE", "ADDR_PHONE", "ADDR_FAX", "MANAGER", "OFFICE_ACCOUNT", "OFFICE_FINANCE", "AUDITOR", "AUDITOR_ADDR", "MEMBNO_FORMAT", "MEMNOMAIN_DOCCODE", "MEMNOCO_DOCCODE", "MEMNOMAIN_SUFFIX", "MEMNOCO_SUFFIX", "RECEIPT_REMARK1", "RECEIPT_REMARK2", "COOPLOGO_PATH", "RETRY_AGE", "RETRY_MONTH", "RETRY_DAY", "MAXMBAGE_AMT", "MAXMBWORKAGE_AMT", "MAXAPPLNEW_AMT", "PREFIX_COOP", "CHGGRPMBTYPE_FLAG") VALUES (:COOP_ID, :COOP_NAME, :COOP_CONTROL, :COOP_SUBTYPE, :ADDR_NO, :ADDR_MOO, :ADDR_ROAD, :ADDR_TAMBOL, :ADDR_AMPHUR, :ADDR_PROVINCE, :ADDR_POSTCODE, :ADDR_PHONE, :ADDR_FAX, :MANAGER, :OFFICE_ACCOUNT, :OFFICE_FINANCE, :AUDITOR, :AUDITOR_ADDR, :MEMBNO_FORMAT, :MEMNOMAIN_DOCCODE, :MEMNOCO_DOCCODE, :MEMNOMAIN_SUFFIX, :MEMNOCO_SUFFIX, :RECEIPT_REMARK1, :RECEIPT_REMARK2, :COOPLOGO_PATH, :RETRY_AGE, :RETRY_MONTH, :RETRY_DAY, :MAXMBAGE_AMT, :MAXMBWORKAGE_AMT, :MAXAPPLNEW_AMT, :PREFIX_COOP, :CHGGRPMBTYPE_FLAG) select * from cmcoopmaster UPDATE "CMCOOPMASTER" SET "COOP_ID" = :COOP_ID, "COOP_NAME" = :COOP_NAME, "COOP_CONTROL" = :COOP_CONTROL, "COOP_SUBTYPE" = :COOP_SUBTYPE, "ADDR_NO" = :ADDR_NO, "ADDR_MOO" = :ADDR_MOO, "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, "MANAGER" = :MANAGER, "OFFICE_ACCOUNT" = :OFFICE_ACCOUNT, "OFFICE_FINANCE" = :OFFICE_FINANCE, "AUDITOR" = :AUDITOR, "AUDITOR_ADDR" = :AUDITOR_ADDR, "MEMBNO_FORMAT" = :MEMBNO_FORMAT, "MEMNOMAIN_DOCCODE" = :MEMNOMAIN_DOCCODE, "MEMNOCO_DOCCODE" = :MEMNOCO_DOCCODE, "MEMNOMAIN_SUFFIX" = :MEMNOMAIN_SUFFIX, "MEMNOCO_SUFFIX" = :MEMNOCO_SUFFIX, "RECEIPT_REMARK1" = :RECEIPT_REMARK1, "RECEIPT_REMARK2" = :RECEIPT_REMARK2, "COOPLOGO_PATH" = :COOPLOGO_PATH, "RETRY_AGE" = :RETRY_AGE, "RETRY_MONTH" = :RETRY_MONTH, "RETRY_DAY" = :RETRY_DAY, "MAXMBAGE_AMT" = :MAXMBAGE_AMT, "MAXMBWORKAGE_AMT" = :MAXMBWORKAGE_AMT, "MAXAPPLNEW_AMT" = :MAXAPPLNEW_AMT, "PREFIX_COOP" = :PREFIX_COOP, "CHGGRPMBTYPE_FLAG" = :CHGGRPMBTYPE_FLAG WHERE (("COOP_ID" = :Original_COOP_ID))