Hello everbody,



I need your opinion again.



I am passing several parameters to a stored procedure using a single

variable named "objParam".  With this method, is the program stable?

("tanggapComp" has the value coming from a textbox.)



Here it is:

set objParam = objCommand.CreateParameter("compName", adVariant,

adParamInput, 20)

objCommand.Parameters.Append objParam

objCommand.Parameters("compName") = tanggapComp



set objParam = objCommand.CreateParameter("acronym", adVariant,

adParamInput, 20)

objCommand.Parameters.Append objParam

objCommand.Parameters("acronym") = tanggapComp



thank you very much for your kind responses.

Bay