Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Send Memo Field to SQL Server Image Data Type
Message
From
26/10/2004 08:00:41
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Client/server
Title:
Send Memo Field to SQL Server Image Data Type
Environment versions
Visual FoxPro:
VFP 8
OS:
Windows XP SP2
Database:
MS SQL Server
Miscellaneous
Thread ID:
00954503
Message ID:
00954503
Views:
41
Hello,


I want to save files inside a SQL Server table.
The table has a column of type image

I have a remote view pointing to this table

I put the file in memory with filetostr
I replace the remote view's memo field with the memory string
Finally I tableupdate the view.

This works fine.
But I have a problem with large files. If the file is large, I can put it completely in the memo field. But only the first 16 Mb gets saved in the SQL Server Table.

Any clue ?
Thanks.
Next
Reply
Map
View

Click here to load this message in the networking platform