Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 615
  • Last Modified:

CreateParamter for Memo Field in ASP and Access

I am using ASP and ACcess. What should I give in the CreateParameter function for vartype for MEmo field in the backend which is MS Access.

CMD_ISMP_INFO.Parameters.Append CMD_ISMP_INFO.CreateParameter("Description",adVarChar,adParamInput,255)
   


0
tech_question
Asked:
tech_question
  • 3
1 Solution
 
tech_questionAuthor Commented:
CMD_ISMP_INFO.Parameters.Append CMD_ISMP_INFO.CreateParameter("Description",?,adParamInput,?)
   

Please fill in the "?" marks , the Description field is a Memo Field in Access Database. I am using ASP as front end .
0
 
SlimshaneeyCommented:
Change adVarChar to

adLongVarChar
0
 
SlimshaneeyCommented:
ie
CMD_ISMP_INFO.Parameters.Append CMD_ISMP_INFO.CreateParameter("Description",adLongVarChar,adParamInput)
0
 
SlimshaneeyCommented:
If it throws an error for not specifiying the length, try this:
CMD_ISMP_INFO.Parameters.Append CMD_ISMP_INFO.CreateParameter("Description",adLongVarChar, adParamInput, 2147483647)
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now