Do not save the file in the database. Keep the file on disk and just save the filename.
>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
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer