You may want to look into the FILESTREAM attribute for the varbinary(max) column
See discusion here
http://stackoverflow.com/questions/13420305/storing-files-in-sql-serverand more info here
http://technet.microsoft.com/en-us/library/bb933993(v=sql.105).aspx>Hello comunity
>
>I need to create a program in my software that can save a file (zip, jpg, doc, pdf ..) in the line of my document .
>
>My database can be SQL Server 2012 or 2005.2008 and my front end is in VFP9.
>
>I know that in my sql server, table must have a field of type BLOB.
>
>How can I create a program in VFP9 that can open Windows explorer to SELECT the file that i want to attach , and save the file on the line where I have the cursor?
>It would also be possible later to extract the file to my hard disk in a place that i choose to open it?
>
>Does anyone have or have made a program for this situation that you can share?
>
>I appreciate all the help.
>
>Best regards
>
>Luis Santos
Gregory