Daniel,
What is the max size of PDF or any other file that can be inserted this way?
BTW, In VFP8 and later STRCONV(, 15) can be used to convert string to hexa-decimal.
>
>There is another way to upload binary data from VFP to a SQL Server image field. You have to send the binary data as HEX. The code below should give you an idea. Unfortunately, I don't know of any other way to retrieve binary data from SQL Server other than the hack with the General/Memo field described in Vlad's article.
>
>
>*-- convert PDF to HEX
>lcHex = StrToHex(FILETOSTR("c:\temp\SomeFile.pdf"))
>*-- add to SQL Server
>SQLEXEC(lnSql, "INSERT INTO YourTable (ImageField) VALUES(" + lcHex + ")")
>
<snip>
--sb--