Page 1 of 1
Truncated Memo Fields
Posted: Fri Jan 23, 2009 1:48 pm
by westover
I have a report that pulls several fields, including one Memo field, and exports them to a CSV file. However, the Memo field (used for a product description) seems to be truncated after about 11,770 characters or so. Is there a limit to the length of data that can be pulled out of the Memo fields? If so is there any way around this limitation? ____My client says there is more data in that field (it^s an HTML description of a product) but is getting cut off. I^ve checked the data in the CSV file and it does look like it^s being truncated in the middle of some of the HTML.____Thanks for your help.
=> RE: Truncated Memo Fields
Posted: Wed Jan 28, 2009 2:21 pm
by kfleming
There is a limit to what we will return from a memo field. This restriction has always been in the product.____Kathleen__R&R Support
==> RE: Truncated Memo Fields
Posted: Thu Jan 29, 2009 10:53 am
by westover
>There is a limit to what we will return from a memo field. __>This restriction has always been in the product. __>__>Kathleen __>R&R Support ____Is there any documentation of this limit anywhere? What is the limit? My client is asking. This may cost them a lot of money to work around.__
===> RE: Truncated Memo Fields
Posted: Fri Jan 30, 2009 11:43 am
by kfleming
The limit is closer to 1.2 million characters. Maybe something in the memo field itself is causing R&R to think that has reached the end of the field?__I can send a sample table with a big memo that you can test if you want.____Kathleen__R&R Support