Dizzy

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);

Dizzy

ok I think ive found it

I have to use AppendChunk for Text & memo fields thankyou google