Information générale
Titre:
Storing binary files ni SQL Server binary fields
Hi there!
I'm just about to finish my first SQL-Server based app.
I have a table on MS SQL Server where I need to store entire binary FILES (e.g. a Word Document) in a binary FIELD, but I can't figure out what syntax to use to load or retrieve that information.
Could you give me a pointer as to what to do, e.g. where to look or what command to use? I can see that SQL Passthrough won't work, because I cannot use something like UPDATE MYTABLE SET BINARYFIELD=FILETOSTR("WORDDOC.DOC") WHERE RECID=5
But that's really what I want to do
Does anyone have any ideas as to what to do. I figure it needs an ADO object, but how???
Thanks so much!
Hermann Strijewski
Clearwater, FL
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement