Improve company productivity with a Business Account.Sign Up

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

"Data Truncated" with Memo-field (CRecordset)

Hi all,
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!
Melissa      
0
MelissaC
Asked:
MelissaC
  • 4
  • 2
1 Solution
 
MelissaCAuthor Commented:
Adjusted points to 100
0
 
MelissaCAuthor Commented:
Adjusted points to 140
0
 
connexCommented:
What is the nMaxlength parameter of the RFX_Text-Call?


0
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
MelissaCAuthor Commented:
Adjusted points to 185
0
 
MelissaCAuthor Commented:
Thanks for the hint, connex. I found out the problem. It was in the RFX_Text call. If you propose the answer, I'll give you the points. Thanks!
0
 
connexCommented:
as wished .)

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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