Expiring Today—Celebrate National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

"Data Truncated" with Memo-field (CRecordset)

Posted on 1998-09-07
6
Medium Priority
?
508 Views
Last Modified: 2013-11-20
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
Comment
Question by:MelissaC
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 2
6 Comments
 
LVL 2

Author Comment

by:MelissaC
ID: 1321867
Adjusted points to 100
0
 
LVL 2

Author Comment

by:MelissaC
ID: 1321868
Adjusted points to 140
0
 
LVL 2

Expert Comment

by:connex
ID: 1321869
What is the nMaxlength parameter of the RFX_Text-Call?


0
Will your db performance match your db growth?

In Percona’s white paper “Performance at Scale: Keeping Your Database on Its Toes,” we take a high-level approach to what you need to think about when planning for database scalability.

 
LVL 2

Author Comment

by:MelissaC
ID: 1321870
Adjusted points to 185
0
 
LVL 2

Author Comment

by:MelissaC
ID: 1321871
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
 
LVL 2

Accepted Solution

by:
connex earned 540 total points
ID: 1321872
as wished .)

0

Featured Post

Survive A High-Traffic Event with Percona

Your application or website rely on your database to deliver information about products and services to your customers. You can’t afford to have your database lose performance, lose availability or become unresponsive – even for just a few minutes.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Exception Handling is in the core of any application that is able to dignify its name. In this article, I'll guide you through the process of writing a DRY (Don't Repeat Yourself) Exception Handling mechanism, using Aspect Oriented Programming.
Ready to get certified? Check out some courses that help you prepare for third-party exams.
This video will show you how to get GIT to work in Eclipse.   It will walk you through how to install the EGit plugin in eclipse and how to checkout an existing repository.
How to fix incompatible JVM issue while installing Eclipse While installing Eclipse in windows, got one error like above and unable to proceed with the installation. This video describes how to successfully install Eclipse. How to solve incompa…

719 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question