VFPOLEDB - Repeating 512 characters in Memo field  
Author Message
Jon Messer





PostPosted: Visual FoxPro General, VFPOLEDB - Repeating 512 characters in Memo field Top

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




Visual FoxPro2  
 
 
Alex Feldstein





PostPosted: Visual FoxPro General, VFPOLEDB - Repeating 512 characters in Memo field Top

Never seen that behavior.

Only thing that comes to mind is to check the SET BLOCKSIZE command:

http://msdn.microsoft.com/library/default.asp url=/library/en-us/dv_foxhelp9/html/94830793-50f6-4dce-a3a9-38b1bcece01d.asp frame=true