DELETE FROM "CMCOOPCONSTANT" WHERE (("COOP_NO" = :Original_COOP_NO)) INSERT INTO "CMCOOPCONSTANT" ("COOP_NO", "COOP_NAME", "COOP_ADDR", "TAMBOL", "DISTRICT_CODE", "PROVINCE_CODE", "POSTCODE", "COOP_TEL", "COOP_FAX", "CHAIRMAN", "MANAGER", "VICEMANAGER", "ASSISTANT", "OFFICE_ACCOUNT", "OFFICE_FINANCE", "AUDITOR", "AUDITOR_ADDR", "MEMBNO_FORMAT", "RETRY_AGE", "RETRY_MONTH", "DISPLAY_COLL", "PERIOD_MBRETURN", "RECEIPT_REMARK1", "RECEIPT_REMARK2", "MEMNOMAIN_DOCCODE", "MEMNOREF_DOCCODE", "MEMNOMAIN_SUFFIX", "MEMNOREF_SUFFIX", "COMEMNO_SUFFIX", "COOP_ROAD", "DIVAVG_PER", "DIVAVG_REMARK1", "DIVAVG_REMARK2", "DIVAVG_REMARK3", "COOP_TAXID", "FORMOBJECT_CONFIRMBAL", "FORMOBJECT_SLRECEIPT", "APPROVE_PASSWORD", "CHAIRMAN_PIC", "SITE", "RECEIPT_REMARK3", "DISTRICT_DESC", "PROVINCE_DESC", "RETRY_DAY", "MAXMBAGE_ATM", "MAXMBWORKAGE_ATM", "MAXAPPLNEW_AMT", "LASTDIVAVG_YEAR", "COOP_CONTROL") VALUES (:COOP_NO, :COOP_NAME, :COOP_ADDR, :TAMBOL, :DISTRICT_CODE, :PROVINCE_CODE, :POSTCODE, :COOP_TEL, :COOP_FAX, :CHAIRMAN, :MANAGER, :VICEMANAGER, :ASSISTANT, :OFFICE_ACCOUNT, :OFFICE_FINANCE, :AUDITOR, :AUDITOR_ADDR, :MEMBNO_FORMAT, :RETRY_AGE, :RETRY_MONTH, :DISPLAY_COLL, :PERIOD_MBRETURN, :RECEIPT_REMARK1, :RECEIPT_REMARK2, :MEMNOMAIN_DOCCODE, :MEMNOREF_DOCCODE, :MEMNOMAIN_SUFFIX, :MEMNOREF_SUFFIX, :COMEMNO_SUFFIX, :COOP_ROAD, :DIVAVG_PER, :DIVAVG_REMARK1, :DIVAVG_REMARK2, :DIVAVG_REMARK3, :COOP_TAXID, :FORMOBJECT_CONFIRMBAL, :FORMOBJECT_SLRECEIPT, :APPROVE_PASSWORD, :CHAIRMAN_PIC, :SITE, :RECEIPT_REMARK3, :DISTRICT_DESC, :PROVINCE_DESC, :RETRY_DAY, :MAXMBAGE_ATM, :MAXMBWORKAGE_ATM, :MAXAPPLNEW_AMT, :LASTDIVAVG_YEAR, :COOP_CONTROL) select * from cmcoopconstant UPDATE "CMCOOPCONSTANT" SET "COOP_NO" = :COOP_NO, "COOP_NAME" = :COOP_NAME, "COOP_ADDR" = :COOP_ADDR, "TAMBOL" = :TAMBOL, "DISTRICT_CODE" = :DISTRICT_CODE, "PROVINCE_CODE" = :PROVINCE_CODE, "POSTCODE" = :POSTCODE, "COOP_TEL" = :COOP_TEL, "COOP_FAX" = :COOP_FAX, "CHAIRMAN" = :CHAIRMAN, "MANAGER" = :MANAGER, "VICEMANAGER" = :VICEMANAGER, "ASSISTANT" = :ASSISTANT, "OFFICE_ACCOUNT" = :OFFICE_ACCOUNT, "OFFICE_FINANCE" = :OFFICE_FINANCE, "AUDITOR" = :AUDITOR, "AUDITOR_ADDR" = :AUDITOR_ADDR, "MEMBNO_FORMAT" = :MEMBNO_FORMAT, "RETRY_AGE" = :RETRY_AGE, "RETRY_MONTH" = :RETRY_MONTH, "DISPLAY_COLL" = :DISPLAY_COLL, "PERIOD_MBRETURN" = :PERIOD_MBRETURN, "RECEIPT_REMARK1" = :RECEIPT_REMARK1, "RECEIPT_REMARK2" = :RECEIPT_REMARK2, "MEMNOMAIN_DOCCODE" = :MEMNOMAIN_DOCCODE, "MEMNOREF_DOCCODE" = :MEMNOREF_DOCCODE, "MEMNOMAIN_SUFFIX" = :MEMNOMAIN_SUFFIX, "MEMNOREF_SUFFIX" = :MEMNOREF_SUFFIX, "COMEMNO_SUFFIX" = :COMEMNO_SUFFIX, "COOP_ROAD" = :COOP_ROAD, "DIVAVG_PER" = :DIVAVG_PER, "DIVAVG_REMARK1" = :DIVAVG_REMARK1, "DIVAVG_REMARK2" = :DIVAVG_REMARK2, "DIVAVG_REMARK3" = :DIVAVG_REMARK3, "COOP_TAXID" = :COOP_TAXID, "FORMOBJECT_CONFIRMBAL" = :FORMOBJECT_CONFIRMBAL, "FORMOBJECT_SLRECEIPT" = :FORMOBJECT_SLRECEIPT, "APPROVE_PASSWORD" = :APPROVE_PASSWORD, "CHAIRMAN_PIC" = :CHAIRMAN_PIC, "SITE" = :SITE, "RECEIPT_REMARK3" = :RECEIPT_REMARK3, "DISTRICT_DESC" = :DISTRICT_DESC, "PROVINCE_DESC" = :PROVINCE_DESC, "RETRY_DAY" = :RETRY_DAY, "MAXMBAGE_ATM" = :MAXMBAGE_ATM, "MAXMBWORKAGE_ATM" = :MAXMBWORKAGE_ATM, "MAXAPPLNEW_AMT" = :MAXAPPLNEW_AMT, "LASTDIVAVG_YEAR" = :LASTDIVAVG_YEAR, "COOP_CONTROL" = :COOP_CONTROL WHERE (("COOP_NO" = :Original_COOP_NO))