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

Click here to load this message in the networking platform