I am working with developers who are trying to populate a VFP DBF memo field with text held in an SQL VARCHAR(4000) field.

When run, the code populates the DBF memo field with the correct number of characters but when you check the content of the memo field it contains nothing but the first 512 characters of the VARCHAR field repeated over and over again.

We've upgraded to the most recent version of OLE driver but the issue still occurs.

The strange thing is that on the development machine the issue does not exist, even with fields using the full 4000 characters in the SQL DB, but we can not identify where the difference in configuration is! Could it be a buffer setting I need to define in the registry

Can anyone help