[QD] 행삽입,변경,삭제 쿼리

OZ Query Designer 3.5v
Application에서 사용할 수 있다.

삽입

insert into TEST_TABLE1
(#@ARG_SF1#, #@ARG_SF2#, #@ARG_SF3#)
values
('#Master.value1#','#@ARG_SV2#','#@ARG_SV3#')

변경

update TEST_TABLE1

set
#@ARG_SF1# = '#@ARG_SV1#',
#@ARG_SF2# = '#@ARG_SV2#',
#@ARG_SF3# = '#@ARG_SV3#'
where
#@ARG_DF1# = #Master.value1# and
#@ARG_DF2# = '#@ARG_DV2#' and
#@ARG_DF3# = '#@ARG_DV3#'

string sql;

sql = "UPDATE TEST_TABLE1 SET [#@ARG_SF1#] = '#@ARG_SV1#',";
sql = sql + "[#@ARG_SF2#] = '#@ARG_SV2#',";
sql = sql + "[#@ARG_SF3#] = '#@ARG_SV3#' ";
sql = sql + "WHERE [#@ARG_DF1#] = '#@ARG_DV1#'";
setQueryString(sql);

삭제

delete from TEST_TABLE1
where #@ARG_DF1# = '#@ARG_DV1#'