Store pdf in blob? 1

[buddyrich2]

Can anyone tell me how I can store a PDF in a blob field?

Thanks!

 

[bborissov]

Two ways:
1.

REPLACE YourBLOBField WITH FILETOSTR([PDFFile.PDF])

2.

APPEND MEMO YourBLOBField FROM PDFFile.PDF

Borislav Borissov
VFP9 SP1, SQL Server 2000/2005.
MVP VFP

 

[buddyrich2]

I didn't realize it was so easy! Thanks Borislav!

 

[buddyrich2]

UH OH! How do I get them back out into PDF's again????

 

[baltman]

STRTOFILE(YourBLOBField, [PDFFile.PDF], 0)