ADO CreateParameter on the Command object

Reply Subscribe

Thread Tools

Search this Thread

Jul 12, 2002 | 10:58 AM

Dizzy

Thread Starter

Scooby Regular

Joined: May 2001

Posts: 2,537

Likes: 0

I'm trying to write a parameterised query to insert data into an access memo field and I cant get the sodding thing to work (probably coz I'm hung over

) and I keep getting this error

"[Microsoft][ODBC Microsoft Access Driver]Invalid string or buffer length"

Has anyone else used Command object and care to shed some light?
Thanks in advance

e.g. :

m_pClauseCommand->CommandText = "insert into Clause(ClauseRef, ClauseCode, Title, Content, Created, Ammended ..blah blah..values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,? ,?,?,?,?)";
m_pClauseCommand->CommandType = adCmdText;
m_pClauseCommand->CommandTimeout = 15;

COleVariant oleDefault("");

//Add all the parameters in :/
_ParameterPtr pParam;
pParam = m_pClauseCommand->CreateParameter("ClauseRef", adChar, adParamInput,10,oleDefault);
m_pClauseCommand->Parameters->Append(pParam);
pParam = m_pClauseCommand->CreateParameter("ClauseCode", adChar, adParamInput,20,oleDefault);
m_pClauseCommand->Parameters->Append(pParam);
pParam = m_pClauseCommand->CreateParameter("Title", adChar, adParamInput,255,oleDefault);
m_pClauseCommand->Parameters->Append(pParam);
pParam = m_pClauseCommand->CreateParameter("Content", adLongVarWChar, adParamInput,4096,oleDefault);
m_pClauseCommand->Parameters->Append(pParam);