My question is, is it possible to batch processing multiple update statemens in one conn.execute? if so, how to write the line break (\n) in vbscript?
strSQL=strSQL&"UPDATE TEST SET A = 1 WHERE ID = 1\n";
strSQL=strSQL&""UPDATE TEST SET B = 3 WHERE ID = 2\n";
oConn.Execute(strSQL);
=
sSql = "UPDATE TEST " &_
"SET A = 1" &_
" WHERE ID = 4866" & vbCrLf &_
sSql = sSql & "UPDATE TEST " &_
"SET A = 1" &_
" WHERE ID = 4867"
my_Conn.Execute (sSql)
this generates an error.
Topic Locked
Posted - 05 November 2003 : 05:58:47
