How to use CString with more than 255 characters?

[Radu]

oh dammit!! I was fearing something like that...

Thanks GCDEF!

Any idea what I can do about it?

[GCDEF]

oh dammit!! I was fearing something like that...

Thanks GCDEF!

Any idea what I can do about it?

Read up on RFX_LongBinary. It's a little more involved, but that's what you use for transferring large amounts of data.

[micknustiunimik]

No...I am sure based in the class code itself...

Well, but INT_MAX (2,147,483,647) is bigger than the usable space for a Win32 process, e.g. 2,147,352,576 for NT.

[ovidiucucu]

Right!
Never trust a stuff before test it!

[Andreas Masur]

Well, but INT_MAX (2,147,483,647) is bigger than the usable space for a Win32 process, e.g. 2,147,352,576 for NT.

So? It is stilll valid that a 'CString' can hold up to INT_MAX - 1 characters...whether the underlying operating system supports it or not is a different story....

[Hokutata]

So? It is stilll valid that a 'CString' can hold up to INT_MAX - 1 characters...whether the underlying operating system supports it or not is a different story....

In fact it cannot. Just it tries.

[Drabert]

RFX_Text has a 255 character limit. That's probably your problem.

Bringing up an old post... is there a way around this? i am trying to write more text to an access database using OBDC and RecordSet

any suggestions?

[GCDEF]

Bringing up an old post... is there a way around this? i am trying to write more text to an access database using OBDC and RecordSet

any suggestions?

I don't think an Access text field can hold more than 255 characters anyway. As I mentioned earler, RFX_LongBinary will let you transfer BLOBs.

[Radu]

Bringing up an old post... is there a way around this? i am trying to write more text to an access database using OBDC and RecordSet

any suggestions?

Hi Drabert,

I was trying to do something with RFX_LongBinary but didn't get too far because it's not straightforward and I didn't have the time to go too deep on that. However if you find a solution, I would appreciate alot if you could tell me how it works!!
Hope to hear from you!

[VictorN]

I don't think an Access text field can hold more than 255 characters anyway. As I mentioned earler, RFX_LongBinary will let you transfer BLOBs.

Yes, the Access text field cannot hold more than 255 characters. However, the Memo field can. The memo field limit depends on the MS Access version.
From MSDN (ACC: Concatenation of Memo Fields Creates Text Field ):

Text fields have a limit of 255 characters; Memo fields can contain up to 32,000 characters in Microsoft Access 1.x, and up to 64,000 characters in Microsoft Access 2.0 or later.

[Drabert]

ok i did a lot more research on here and found what you were talking about with the memo field but i am getting the truncate problem because the CString is too large... i tried this

RFX_Text(pDX, IDC_DESCRIPTION, m_pSet->m_Description, 1500,SQL_LONGVARCHAR);

but it didnt work... still getting the truncate problem...

any sugestions? or am i totally doing this incorrectly?