Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Send Memo Field to SQL Server Image Data Type
Message
From
27/10/2004 04:26:53
 
General information
Forum:
Visual FoxPro
Category:
Client/server
Environment versions
Visual FoxPro:
VFP 8
OS:
Windows XP SP2
Database:
MS SQL Server
Miscellaneous
Thread ID:
00954503
Message ID:
00954791
Views:
19
Hi Borislav,

The problem is not about passing the file through memory.
The Memo field is correctly replaced with the file. In the Memo field I can put the whole of the file.

The problem is just when I tableupdate the view. The remote SQL Server Table receives only the first 16 Mb of the Memo Field. The remainder of the Memo field doesn't get to the SQL Server Table.

>Francisco,
>According to help: "Note that the size of the character string FILETOSTR( ) returns can be very large. The amount of available memory or disk space determines if you can store the character string to a memory variable, array element, or memo field."
>
>Why You not just replace to Memo Field with FILTOSTR() w/o first load it into memory?
>
>
Previous
Reply
Map
View

Click here to load this message in the networking platform