Is there any way to reset a adodb command?
i have this code:
auxString = xmlDoc.documentElement.XML
auxLong = Len(auxString)
cmd.ActiveConnection = con
cmd.CommandText = "PLANOS_PACK.Insert_Data"
cmd.CommandType = adCmdStoredProc
Set InputParam = cmd.CreateParameter("input", adLongVarChar,
adParamInput, auxLong, auxString)
cmd.Parameters.Append InputParam
cmd.Execute
that is in a loop, it works for the first iteration, but in the second
it gives me an error, founded < when expecting string delimeter
I can do it without the cycle, but then i have a string to large and
receive errors like, "result of string concatenation is too long" or
"string literal is too long" or even "missing expression".
any help would be appreciated.
Thanks,
--
Jlorga
------------------------------------------------------------------------
Jlorga's Profile:
http://www.excelforum.com/member.php...o&userid=31707
View this thread:
http://www.excelforum.com/showthread...hreadid=519331