Hi
What is the max string value for adVarChar? The reason I ask is that I am sending the following parameter to a SQL 2005 stored procedure.
Set clsParm = .CreateParamete r("@ProductionF ull", adVarChar, adParamOutput, 1200000000)
.Parameters.App end clsParm
I really do not know what the length of the output parameter will be so for now I have 1200000000 just for testing. I wish there was a const provided by VBA.
Thanks!!
What is the max string value for adVarChar? The reason I ask is that I am sending the following parameter to a SQL 2005 stored procedure.
Set clsParm = .CreateParamete r("@ProductionF ull", adVarChar, adParamOutput, 1200000000)
.Parameters.App end clsParm
I really do not know what the length of the output parameter will be so for now I have 1200000000 just for testing. I wish there was a const provided by VBA.
Thanks!!