I haven't tried it myself, but what about something like:
s=FILETOSTR("WORDDOC.DOC")
UPDATE MYTABLE SET BINARYFIELD=s WHERE RECID=5
Cheers,
Peter
>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
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only