CRecordset ? DoFieldExchange ??

[zinc_z]

Hi , I am having problem when I assign a string more than 255 characters to a CRecordset memeber like (m_Result is a CString) Res->m_Result=str1; (str1 is more than 255 characters) UpDate(); and I get a exception "Debug Assertion Failed , DBFRX line 287 ". Is there any other way of setting string more than 255 characters using CRecordset->Update() ??? Thanks, ZINC

[David Crow]

What type/size of field in your table is m_Result tied to?

---

"The greatest good you can do for another is not just to share your riches but to reveal to him his own." - Benjamin Disraeli

[zinc_z]

its a ACCESS table and field is of ntext type

[David Crow]

zinc_z wrote:

...and field is of ntext type

Not sure how 'ntext' compares to 'text' but how large is the field?

---

"The greatest good you can do for another is not just to share your riches but to reveal to him his own." - Benjamin Disraeli

[zinc_z]

its of CString type

[David Crow]

You have already indicated that m_Result is a CString object. My question was about the field in the database.

---

"The greatest good you can do for another is not just to share your riches but to reveal to him his own." - Benjamin Disraeli

[zinc_z]

m_Result is bound to of ntext(length 16) type field in SQL Server . I have tried to change the field to varchar (length 700) but no diff. I still got the same exception. any other sugestions ? Regards, ZINC