isql1 = "insert into Salary1 values ('" + (Trim(MaskEdBox1.Text) + Trim(MaskEdBox2.Text)) + "','" + Trim(IIf(IsNull(ars5("code")), "", ars5("code"))) + "','" + Trim(IIf(IsNull(ars5("codenm")), "", ars5("codenm"))) + _
"','" + Trim(IIf(IsNull(ars5("buseo")), "", ars5("buseo"))) + "','" + Trim(IIf(IsNull(ars5("sex")), "", ars5("sex"))) + "','" + Trim(IIf(IsNull(ars5("marry")), "", ars5("marry"))) + _
"','" + Trim(IIf(IsNull(ars5("child")), "", ars5("child"))) + "','" + Trim(IIf(IsNull(ars5("old")), "", ars5("old"))) + "','" + Trim(IIf(IsNull(ars5("workyn")), "", ars5("workyn"))) + _
"','" + Trim(IIf(IsNull(ars5("sexno")), "", ars5("sexno"))) + "','" + Trim(IIf(IsNull(ars5("exp_dt")), "", ars5("exp_dt"))) + "','" + Trim(IIf(IsNull(ars5("exp_dt1")), "", ars5("exp_dt1"))) + _
"','" + Trim(IIf(IsNull(ars5("accno")), "", ars5("accno"))) + "','" + Trim(IIf(IsNull(ars5("sosok")), "", ars5("sosok"))) & "'," & Val(IIf(IsNull(ars5("base")), 0, ars5("base"))) & "," & Val(IIf(IsNull(ars5("jik")), 0, ars5("jik"))) & _
"," & Val(IIf(IsNull(ars5("base1")), 0, ars5("base1"))) & "," & Val(IIf(IsNull(ars5("food")), 0, ars5("food"))) & "," & Val(IIf(IsNull(ars5("gift")), 0, ars5("gift"))) & _
"," & Val(IIf(IsNull(ars5("tax")), 0, ars5("tax"))) & "," & Val(IIf(IsNull(ars5("tax1")), 0, ars5("tax1"))) & "," & Val(IIf(IsNull(ars5("tax2")), 0, ars5("tax2"))) & _
"," & Val(IIf(IsNull(ars5("tax3")), 0, ars5("tax3"))) & "," & Val(IIf(IsNull(ars5("tax4")), 0, ars5("tax4"))) & "," & Val(IIf(IsNull(ars5("tax5")), 0, ars5("tax5"))) & _
"," & Val("0") & "," & Val("0") & ")"
adoOraCon.Execute (isql1)
insert문을 _ 를 사용해서 계속연결했는데
이 문장을 _ 를 사용하지 않고 쿼리를 작성할수 있나요....
update은 수정을 했는데 insert문은 쉽게 풀리지가 않습니다.
답변을 부탁드립니다.
|