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.