Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
reseting adodb commands? help please
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reseting to 0. | Excel Discussion (Misc queries) | |||
VBA reseting variables | Excel Discussion (Misc queries) | |||
VBA reseting variables | Excel Discussion (Misc queries) | |||
name box reseting | Excel Discussion (Misc queries) | |||
Reseting integers | Excel Programming |