February 9th, 2004, 08:17 PM
createparameter for TEXT.
When adding a parameter that is of type TEXT in the database, what replaces the bit that might otherwise say 'adVarChar' or 'adInteger'?
CreateParameter("@QuizQuestionOptionText", adVarChar, adParamInput)
February 10th, 2004, 01:40 PM
adLongVarChar (I think)
I don't know for sure (I saw this someplace else online), but try: adLongVarChar.
February 10th, 2004, 02:51 PM
adLongVarChar doesn't appear to work either:
Parameter object is improperly defined. Inconsistent or incomplete information was provided.
On further investigation I've found that adLongVarChar is correct:
Perhaps it is the declaration in the stored procedure that is incorrect?
I have declared it as 'TEXT' ?