By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,967 Members | 1,690 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,967 IT Pros & Developers. It's quick & easy.

Max string value

P: 3
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 = .CreateParameter("@ProductionFull", adVarChar, adParamOutput, 1200000000)
.Parameters.Append 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!!
Jun 25 '08 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.