DELETE FROM "LNLAWMBMASTER" WHERE (("COOP_ID" = :Original_COOP_ID) AND ("MEMBER_NO" = :Original_MEMBER_NO)) INSERT INTO "LNLAWMBMASTER" ("COOP_ID", "MEMBER_NO", "PRENAME_CODE", "MEMB_NAME", "MEMB_SURNAME", "MEMBGROUP_CODE", "MEMBTYPE_CODE", "BIRTH_DATE", "MEMBER_DATE", "ADDR_NO", "ADDR_MOO", "ADDR_SOI", "ADDR_VILLAGE", "ADDR_ROAD", "TAMBOL_CODE", "AMPHUR_CODE", "PROVINCE_CODE", "ADDR_POSTCODE", "ADDR_PHONE", "MATE_NAME", "CARD_PERSON", "REMARK", "MEMBER_TYPE", "T_PROVINCE", "T_AMPHUR", "T_TAMBOL") VALUES (:COOP_ID, :MEMBER_NO, :PRENAME_CODE, :MEMB_NAME, :MEMB_SURNAME, :MEMBGROUP_CODE, :MEMBTYPE_CODE, :BIRTH_DATE, :MEMBER_DATE, :ADDR_NO, :ADDR_MOO, :ADDR_SOI, :ADDR_VILLAGE, :ADDR_ROAD, :TAMBOL_CODE, :AMPHUR_CODE, :PROVINCE_CODE, :ADDR_POSTCODE, :ADDR_PHONE, :MATE_NAME, :CARD_PERSON, :REMARK, :MEMBER_TYPE, :T_PROVINCE, :T_AMPHUR, :T_TAMBOL) select * from lnlawmbmaster UPDATE "LNLAWMBMASTER" SET "COOP_ID" = :COOP_ID, "MEMBER_NO" = :MEMBER_NO, "PRENAME_CODE" = :PRENAME_CODE, "MEMB_NAME" = :MEMB_NAME, "MEMB_SURNAME" = :MEMB_SURNAME, "MEMBGROUP_CODE" = :MEMBGROUP_CODE, "MEMBTYPE_CODE" = :MEMBTYPE_CODE, "BIRTH_DATE" = :BIRTH_DATE, "MEMBER_DATE" = :MEMBER_DATE, "ADDR_NO" = :ADDR_NO, "ADDR_MOO" = :ADDR_MOO, "ADDR_SOI" = :ADDR_SOI, "ADDR_VILLAGE" = :ADDR_VILLAGE, "ADDR_ROAD" = :ADDR_ROAD, "TAMBOL_CODE" = :TAMBOL_CODE, "AMPHUR_CODE" = :AMPHUR_CODE, "PROVINCE_CODE" = :PROVINCE_CODE, "ADDR_POSTCODE" = :ADDR_POSTCODE, "ADDR_PHONE" = :ADDR_PHONE, "MATE_NAME" = :MATE_NAME, "CARD_PERSON" = :CARD_PERSON, "REMARK" = :REMARK, "MEMBER_TYPE" = :MEMBER_TYPE, "T_PROVINCE" = :T_PROVINCE, "T_AMPHUR" = :T_AMPHUR, "T_TAMBOL" = :T_TAMBOL WHERE (("COOP_ID" = :Original_COOP_ID) AND ("MEMBER_NO" = :Original_MEMBER_NO))