Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Send Memo Field to SQL Server Image Data Type
Message
 
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:
00954614
Views:
13
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?




>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.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform