469,327 Members | 1,242 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,327 developers. It's quick & easy.

convert string to type for cmd parameter

hi guys got in pinch here...
Expand|Select|Wrap|Line Numbers
  1. rz.Parameters.Append rz.CreateParameter("@OldAccNo",adDecimal,adParamInput,9,OldAccNo)
  2. rz.Parameters.Append rz.CreateParameter("@NewAccNo",adChar,adParamInput,11,NewAccNo)
  3. rz.Parameters.Append rz.CreateParameter("@RewardNo",adVarChar,adParamInput,15,RewardNo)
  4. rz.Parameters.Append rz.CreateParameter("@NewICNo",adChar,adParamInput,12,NewICNo)
  5. rz.Parameters.Append rz.CreateParameter("@Amounts",adCurrency,adParamInput,,Amounts)
  6. rz.Parameters.Append rz.CreateParameter("@TransDate",adDate,adParamInput,,TransDate)
  7. rz.Parameters.Append rz.CreateParameter("@ReceiptNo",adNumeric,adParamInput,15,ReceiptNo)
  8. rz.Parameters.Append rz.CreateParameter("@POCode",adVarChar,adParamInput,5,POCode)
I need to change all the parameter value from (current)String to selected data type...any ideas
Oct 28 '08 #1
1 2679
1,208 Expert 1GB
i'm really not sure what you are asking here?

Do you mean like
Expand|Select|Wrap|Line Numbers
  1. dim test
  2. test="1" 'this is a string obviously
  3. test=cint(test) 'this converts it to an int
I need more detail on what you are doing and for cmd I am assuming for adodb command?
Oct 28 '08 #2

Post your reply

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

Similar topics

4 posts views Thread by John Cotsell | last post: by
14 posts views Thread by rtillmore | last post: by
reply views Thread by suresh191 | last post: by
reply views Thread by listenups61195 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.