DELETE FROM "AMSECUSERS" WHERE (("COOP_ID" = :Original_COOP_ID) AND ("USER_NAME" = :Original_USER_NAME)) INSERT INTO "AMSECUSERS" ("COOP_ID", "USER_NAME", "FULL_NAME", "DESCRIPTION", "PASSWORD", "TERMINAL_NAME", "COOPBRANCH_ID", "USER_ID", "APVLEVEL_ID", "TABLEFIN_CODE", "USER_LEVEL", "USER_TYPE", "POINT_OFCASH", "APVCASH_FLAG", "FREEZ_FLAG", "INITIAL_NAME", "SHOWSALARY_FLAG", "USER_C", "COOP_CONTROL") VALUES (:COOP_ID, :USER_NAME, :FULL_NAME, :DESCRIPTION, :PASSWORD, :TERMINAL_NAME, :COOPBRANCH_ID, :USER_ID, :APVLEVEL_ID, :TABLEFIN_CODE, :USER_LEVEL, :USER_TYPE, :POINT_OFCASH, :APVCASH_FLAG, :FREEZ_FLAG, :INITIAL_NAME, :SHOWSALARY_FLAG, :USER_C, :COOP_CONTROL) select * from amsecusers UPDATE "AMSECUSERS" SET "COOP_ID" = :COOP_ID, "USER_NAME" = :USER_NAME, "FULL_NAME" = :FULL_NAME, "DESCRIPTION" = :DESCRIPTION, "PASSWORD" = :PASSWORD, "TERMINAL_NAME" = :TERMINAL_NAME, "COOPBRANCH_ID" = :COOPBRANCH_ID, "USER_ID" = :USER_ID, "APVLEVEL_ID" = :APVLEVEL_ID, "TABLEFIN_CODE" = :TABLEFIN_CODE, "USER_LEVEL" = :USER_LEVEL, "USER_TYPE" = :USER_TYPE, "POINT_OFCASH" = :POINT_OFCASH, "APVCASH_FLAG" = :APVCASH_FLAG, "FREEZ_FLAG" = :FREEZ_FLAG, "INITIAL_NAME" = :INITIAL_NAME, "SHOWSALARY_FLAG" = :SHOWSALARY_FLAG, "USER_C" = :USER_C, "COOP_CONTROL" = :COOP_CONTROL WHERE (("COOP_ID" = :Original_COOP_ID) AND ("USER_NAME" = :Original_USER_NAME))