How to use CString with more than 255 characters?

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

Thanks GCDEF!

Any idea what I can do about it?

Quote:

---

Originally Posted by Radu

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.

Quote:

---

Originally Posted by Andreas Masur

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.

Right!
Never trust a stuff before test it! :D

Quote:

---

Originally Posted by micknustiunimik

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.... :cool:

Quote:

---

Originally Posted by Andreas Masur

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.... :cool:

---

In fact it cannot. Just it tries. :)

Quote:

---

Originally Posted by GCDEF

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?

Quote:

---

Originally Posted by Drabert

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.

Quote:

---

Originally Posted by Drabert

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!

Quote:

---

Originally Posted by GCDEF

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 ):

Quote:

---

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.

---

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?