select * from yrdivmaster DELETE FROM "YRDIVMASTER" WHERE (("COOP_ID" = :Original_COOP_ID) AND ("MEMBER_NO" = :Original_MEMBER_NO) AND ("DIV_YEAR" = :Original_DIV_YEAR)) INSERT INTO "YRDIVMASTER" ("COOP_ID", "MEMBER_NO", "DIV_YEAR", "DIV_AMT", "DIV_BALAMT", "AVG_AMT", "AVG_BALAMT", "ETC_AMT", "ETC_BALAMT", "ITEM_BALAMT", "SHOP1_AMT", "SHOP2_AMT", "OIL_AMT", "SHOP1_BALAMT", "SHOP2_BALAMT", "OIL_BALAMT", "RICE_AMT", "RICE_BALAMT", "DEPT_AMT", "LOANLAW_AMT", "SHR_AMT") VALUES (:COOP_ID, :MEMBER_NO, :DIV_YEAR, :DIV_AMT, :DIV_BALAMT, :AVG_AMT, :AVG_BALAMT, :ETC_AMT, :ETC_BALAMT, :ITEM_BALAMT, :SHOP1_AMT, :SHOP2_AMT, :OIL_AMT, :SHOP1_BALAMT, :SHOP2_BALAMT, :OIL_BALAMT, :RICE_AMT, :RICE_BALAMT, :DEPT_AMT, :LOANLAW_AMT, :SHR_AMT) select * from yrdivmaster UPDATE "YRDIVMASTER" SET "COOP_ID" = :COOP_ID, "MEMBER_NO" = :MEMBER_NO, "DIV_YEAR" = :DIV_YEAR, "DIV_AMT" = :DIV_AMT, "DIV_BALAMT" = :DIV_BALAMT, "AVG_AMT" = :AVG_AMT, "AVG_BALAMT" = :AVG_BALAMT, "ETC_AMT" = :ETC_AMT, "ETC_BALAMT" = :ETC_BALAMT, "ITEM_BALAMT" = :ITEM_BALAMT, "SHOP1_AMT" = :SHOP1_AMT, "SHOP2_AMT" = :SHOP2_AMT, "OIL_AMT" = :OIL_AMT, "SHOP1_BALAMT" = :SHOP1_BALAMT, "SHOP2_BALAMT" = :SHOP2_BALAMT, "OIL_BALAMT" = :OIL_BALAMT, "RICE_AMT" = :RICE_AMT, "RICE_BALAMT" = :RICE_BALAMT, "DEPT_AMT" = :DEPT_AMT, "LOANLAW_AMT" = :LOANLAW_AMT, "SHR_AMT" = :SHR_AMT WHERE (("COOP_ID" = :Original_COOP_ID) AND ("MEMBER_NO" = :Original_MEMBER_NO) AND ("DIV_YEAR" = :Original_DIV_YEAR))