Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Send Memo Field to SQL Server Image Data Type
Message
 
À
26/10/2004 08:00:41
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Versions des environnements
Visual FoxPro:
VFP 8
OS:
Windows XP SP2
Database:
MS SQL Server
Divers
Thread ID:
00954503
Message ID:
00954614
Vues:
15
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.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform