"Data Truncated" with Memo-field (CRecordset)
Posted on 1998-09-07
I've got a problem reading data from an Microsoft Acess-table (office 97) with a memo field. I derived a class from CRecordset with a wizard and I pointed to the table, so the wizard could create member variables like this:
long m_ID; //unique ID, autonumber
CString m_Label; //Text field
CString m_Text; //Memo field
Whenever I do a MoveNext, the next record is read and the values are stored in the derived CRecordset-object, let's call it CMySet. The problem is: When the memofield exceeds a
certain number of characters (I don't know exactly how many, I don't like counting), I get a CDBException "Data Truncated". But I read somewhere in the help that "A CString object can store up to INT_MAX (2,147,483,647) characters". Does anyone have experience with memofields?
Thanks in advance!