Problem in RFX_Text (CRecordset) While more than 256 char.

Is there a better way than RFX_Text to handle large data fields? using CRecordset..
RFX_Text defaults to 255 characters maximum, I need to set this higher for a Memo field.
I think this is a documented error in MFC.
When i enter the data more than 255 char into the field it breaks. Hope anyone can help me.
manuelfrancisAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Darren_SimonsConnect With a Mentor Commented:
In terms of fixing the code, as you mention you can change the max. characters using something like....

RFX_Text(pFX, _T("[VARIABLE]"), m_Variable, 10000);

where the length you specify is 10000. I am currently using this for a record set talking to SQL Server, which has no concept of memo fields and *always* requires a maximum length to be set.

I don't believe there is another way of doing this, since I imagine other databases work in a similar way to SQL Server
0
 
manuelfrancisAuthor Commented:
Thanks Darren_Simons,

Your answer is quite right and helped me too...
The same answer is there in the VC help and MSDN CD but i did't seen that before.

Thanks once again.

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.

All Courses

From novice to tech pro — start learning today.