Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Send Memo Field to SQL Server Image Data Type
Message
From
28/10/2004 04:41:06
 
 
To
26/10/2004 08:00:41
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:
00955177
Views:
18
Hi.
I was able to send a 240mb file to an Image via RV when i
APPEND MEMO fileguts FROM (cFullFile_Na) OVERWRITE
All the best.

>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.
A moment of silence is our cosmic reset button.
Previous
Reply
Map
View

Click here to load this message in the networking platform