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,
EDITED: ok, done
Bookmarks