DELETE FROM "LNCOLLMASTPROP" WHERE (("COOP_ID" = :Original_COOP_ID) AND ("COLLMAST_NO" = :Original_COLLMAST_NO) AND ("SEQ_NO" = :Original_SEQ_NO)) INSERT INTO "LNCOLLMASTPROP" ("COOP_ID", "COLLMAST_NO", "SEQ_NO", "PROP_DESC") VALUES (:COOP_ID, :COLLMAST_NO, :SEQ_NO, :PROP_DESC) select * from LNCOLLMASTPROP UPDATE "LNCOLLMASTPROP" SET "COOP_ID" = :COOP_ID, "COLLMAST_NO" = :COLLMAST_NO, "SEQ_NO" = :SEQ_NO, "PROP_DESC" = :PROP_DESC WHERE (("COOP_ID" = :Original_COOP_ID) AND ("COLLMAST_NO" = :Original_COLLMAST_NO) AND ("SEQ_NO" = :Original_SEQ_NO)) DELETE FROM "LNCOLLMASTER" WHERE (("COOP_ID" = :Original_COOP_ID) AND ("COLLMAST_NO" = :Original_COLLMAST_NO)) INSERT INTO "LNCOLLMASTER" ("COOP_ID", "COLLMAST_NO", "COLLMASTTYPE_CODE", "LAND_RAVANG", "LAND_DOCNO", "LAND_LANDNO", "LAND_SURVEY", "LAND_BOOKNO", "LAND_PAGENO", "POS_TAMBOL", "POS_AMPHUR", "POS_PROVINCE", "PHOTOAIR_PROVINCE", "PHOTOAIR_NUMBER", "PHOTOAIR_PAGE", "PRICEPER_UNIT") VALUES (:COOP_ID, :COLLMAST_NO, :COLLMASTTYPE_CODE, :LAND_RAVANG, :LAND_DOCNO, :LAND_LANDNO, :LAND_SURVEY, :LAND_BOOKNO, :LAND_PAGENO, :POS_TAMBOL, :POS_AMPHUR, :POS_PROVINCE, :PHOTOAIR_PROVINCE, :PHOTOAIR_NUMBER, :PHOTOAIR_PAGE, :PRICEPER_UNIT) SELECT COOP_ID, COLLMAST_NO, COLLMASTTYPE_CODE, LAND_RAVANG, LAND_DOCNO, LAND_LANDNO, LAND_SURVEY, LAND_BOOKNO, LAND_PAGENO, POS_TAMBOL, POS_AMPHUR, POS_PROVINCE, PHOTOAIR_PROVINCE, PHOTOAIR_NUMBER, PHOTOAIR_PAGE, PRICEPER_UNIT FROM LNCOLLMASTER UPDATE "LNCOLLMASTER" SET "COOP_ID" = :COOP_ID, "COLLMAST_NO" = :COLLMAST_NO, "COLLMASTTYPE_CODE" = :COLLMASTTYPE_CODE, "LAND_RAVANG" = :LAND_RAVANG, "LAND_DOCNO" = :LAND_DOCNO, "LAND_LANDNO" = :LAND_LANDNO, "LAND_SURVEY" = :LAND_SURVEY, "LAND_BOOKNO" = :LAND_BOOKNO, "LAND_PAGENO" = :LAND_PAGENO, "POS_TAMBOL" = :POS_TAMBOL, "POS_AMPHUR" = :POS_AMPHUR, "POS_PROVINCE" = :POS_PROVINCE, "PHOTOAIR_PROVINCE" = :PHOTOAIR_PROVINCE, "PHOTOAIR_NUMBER" = :PHOTOAIR_NUMBER, "PHOTOAIR_PAGE" = :PHOTOAIR_PAGE, "PRICEPER_UNIT" = :PRICEPER_UNIT WHERE (("COOP_ID" = :Original_COOP_ID) AND ("COLLMAST_NO" = :Original_COLLMAST_NO)) DELETE FROM "LNCOLLMASTER" WHERE (("COOP_ID" = :Original_COOP_ID) AND ("COLLMAST_NO" = :Original_COLLMAST_NO)) INSERT INTO "LNCOLLMASTER" ("COOP_ID", "COLLMAST_NO", "DOL_PRINCE", "EST_PERCENT", "EST_PRICE") VALUES (:COOP_ID, :COLLMAST_NO, :DOL_PRINCE, :EST_PERCENT, :EST_PRICE) select coop_id, collmast_no, dol_prince, est_percent, est_price from lncollmaster UPDATE "LNCOLLMASTER" SET "COOP_ID" = :COOP_ID, "COLLMAST_NO" = :COLLMAST_NO, "DOL_PRINCE" = :DOL_PRINCE, "EST_PERCENT" = :EST_PERCENT, "EST_PRICE" = :EST_PRICE WHERE (("COOP_ID" = :Original_COOP_ID) AND ("COLLMAST_NO" = :Original_COLLMAST_NO)) select coop_id, collmast_no, collmasttype_code, bd_village, bd_addrno, bd_addrmoo, bd_soi, bd_road, bd_tambol, bd_amphur, bd_province, bd_type, bd_depreciation, bd_onlandno, bd_sumprice, bd_age from lncollmaster DELETE FROM "LNCOLLMASTER" WHERE (("COOP_ID" = :Original_COOP_ID) AND ("COLLMAST_NO" = :Original_COLLMAST_NO)) INSERT INTO "LNCOLLMASTER" ("COOP_ID", "COLLMAST_NO", "COLLMAST_DESC", "MEMBER_NO") VALUES (:COOP_ID, :COLLMAST_NO, :COLLMAST_DESC, :MEMBER_NO) SELECT COOP_ID, COLLMAST_NO, COLLMAST_DESC, MEMBER_NO FROM LNCOLLMASTER UPDATE "LNCOLLMASTER" SET "COOP_ID" = :COOP_ID, "COLLMAST_NO" = :COLLMAST_NO, "COLLMAST_DESC" = :COLLMAST_DESC, "MEMBER_NO" = :MEMBER_NO WHERE (("COOP_ID" = :Original_COOP_ID) AND ("COLLMAST_NO" = :Original_COLLMAST_NO)) DELETE FROM "LNCOLLMASTBUILDING" WHERE (("COOP_ID" = :Original_COOP_ID) AND ("COLLMAST_NO" = :Original_COLLMAST_NO) AND ("FLOOR_NO" = :Original_FLOOR_NO)) INSERT INTO "LNCOLLMASTBUILDING" ("COOP_ID", "COLLMAST_NO", "FLOOR_NO", "FLOOR_SQUARE", "FLOOR_PRICESQUARE", "FLOOR_SUMPRICE") VALUES (:COOP_ID, :COLLMAST_NO, :FLOOR_NO, :FLOOR_SQUARE, :FLOOR_PRICESQUARE, :FLOOR_SUMPRICE) select coop_id, collmast_no, floor_no, floor_square, floor_pricesquare, floor_sumprice from lncollmastbuilding UPDATE "LNCOLLMASTBUILDING" SET "COOP_ID" = :COOP_ID, "COLLMAST_NO" = :COLLMAST_NO, "FLOOR_NO" = :FLOOR_NO, "FLOOR_SQUARE" = :FLOOR_SQUARE, "FLOOR_PRICESQUARE" = :FLOOR_PRICESQUARE, "FLOOR_SUMPRICE" = :FLOOR_SUMPRICE WHERE (("COOP_ID" = :Original_COOP_ID) AND ("COLLMAST_NO" = :Original_COLLMAST_NO) AND ("FLOOR_NO" = :Original_FLOOR_NO)) DELETE FROM "LNCOLLMASTER" WHERE (("COOP_ID" = :Original_COOP_ID) AND ("COLLMAST_NO" = :Original_COLLMAST_NO)) INSERT INTO "LNCOLLMASTER" ("COOP_ID", "COLLMAST_NO", "DESC_POSITION", "DESC_UTILITY", "DESC_TRAVEL", "DESC_ETC") VALUES (:COOP_ID, :COLLMAST_NO, :DESC_POSITION, :DESC_UTILITY, :DESC_TRAVEL, :DESC_ETC) select coop_id, collmast_no, desc_position, desc_utility, desc_travel, desc_etc from lncollmaster UPDATE "LNCOLLMASTER" SET "COOP_ID" = :COOP_ID, "COLLMAST_NO" = :COLLMAST_NO, "DESC_POSITION" = :DESC_POSITION, "DESC_UTILITY" = :DESC_UTILITY, "DESC_TRAVEL" = :DESC_TRAVEL, "DESC_ETC" = :DESC_ETC WHERE (("COOP_ID" = :Original_COOP_ID) AND ("COLLMAST_NO" = :Original_COLLMAST_NO)) DELETE FROM "LNCOLLMASTER" WHERE (("COOP_ID" = :Original_COOP_ID) AND ("COLLMAST_NO" = :Original_COLLMAST_NO)) INSERT INTO "LNCOLLMASTER" ("COOP_ID", "COLLMAST_NO", "CONDO_REGISTNO", "CONDO_NAME", "CONDO_TOWERNO", "CONDO_FLOOR", "CONDO_ROOMNO", "CONDO_ROOMSIZE", "CONDO_PRICESQUARE", "POS_TAMBOL", "POS_AMPHUR", "POS_PROVINCE", "CONDO_DEPRECIATION", "CONDO_AGE") VALUES (:COOP_ID, :COLLMAST_NO, :CONDO_REGISTNO, :CONDO_NAME, :CONDO_TOWERNO, :CONDO_FLOOR, :CONDO_ROOMNO, :CONDO_ROOMSIZE, :CONDO_PRICESQUARE, :POS_TAMBOL, :POS_AMPHUR, :POS_PROVINCE, :CONDO_DEPRECIATION, :CONDO_AGE) select coop_id, collmast_no, condo_registno, condo_name, condo_towerno, condo_floor, condo_roomno, condo_roomsize, condo_pricesquare, pos_tambol, pos_amphur, pos_province, condo_depreciation, condo_age from lncollmaster UPDATE "LNCOLLMASTER" SET "COOP_ID" = :COOP_ID, "COLLMAST_NO" = :COLLMAST_NO, "CONDO_REGISTNO" = :CONDO_REGISTNO, "CONDO_NAME" = :CONDO_NAME, "CONDO_TOWERNO" = :CONDO_TOWERNO, "CONDO_FLOOR" = :CONDO_FLOOR, "CONDO_ROOMNO" = :CONDO_ROOMNO, "CONDO_ROOMSIZE" = :CONDO_ROOMSIZE, "CONDO_PRICESQUARE" = :CONDO_PRICESQUARE, "POS_TAMBOL" = :POS_TAMBOL, "POS_AMPHUR" = :POS_AMPHUR, "POS_PROVINCE" = :POS_PROVINCE, "CONDO_DEPRECIATION" = :CONDO_DEPRECIATION, "CONDO_AGE" = :CONDO_AGE WHERE (("COOP_ID" = :Original_COOP_ID) AND ("COLLMAST_NO" = :Original_COLLMAST_NO))