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 12:57:37
 
 
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:
00954598
Views:
20
Don't know much about how this works sending the memo to an image file, but would it be possible to send it to a text ( or nText ) type field in SQL. That may work better.

>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.


Charles Hankey

Though a good deal is too strange to be believed, nothing is too strange to have happened.
- Thomas Hardy

Half the harm that is done in this world is due to people who want to feel important. They don't mean to do harm-- but the harm does not interest them. Or they do not see it, or they justify it because they are absorbed in the endless struggle to think well of themselves.

-- T. S. Eliot
Democracy is two wolves and a sheep voting on what to have for lunch.
Liberty is a well-armed sheep contesting the vote.
- Ben Franklin

Pardon him, Theodotus. He is a barbarian, and thinks that the customs of his tribe and island are the laws of nature.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform