Yes, this is the solution. I was able to save about 1000 characters to an
Oracle LongVarChar field.

Thank you.

-Elizabeh
"nmon10egro" <nciecdoalraas@hotmail.com> wrote:
>
>"Elizabeth" <chang.elizabeth@epa.gov> wrote:
>>
>>Hi,
>>
>>I am having problems accessing text data over 256 characters in an Oracle
>>database. I used CDatabase to connect to the database. I created a class
>>from CRecordset and another class from CRecordview to manipulate the data.
>> When I tried to save the text (now has more than 256 char after editing)
>>back to the database, the error message says exceeding 256 characters.

>Thanks.
>>
>>-Elizabeth
>
>=============
>Hi Elizabeth,
> If you're using RFX_Text() to map your CString variable to the table
field,
>then you have to pass a 3rd parameter as the maximum length. By default
>it is 255. So it would look like the following in your code:
>
>void CElizabeth'sRecordView::DoFieldExchange(CFieldExchange* pFX)
>{
> ...
> RFX_Text(pFX, _T("[Key]"), m_Key, 1000 ); // NRM: That is, if 1000 is
>your max length for that field.
> ...
>}
>
> Good luck!
>
>
>Nico