>Is there a way of storing and retrieving files into and out of a fox table.
>I am using vfp 6sp5 and 7sp1. I thought that there was a MSKB article on it
>but I cannot find it.
>
>Basically I want to store any and all file types. My generic solution would
>to store the file as a single BLOB record. Upon retrival I would extract the
>BLOB field into a file and save it locally.
>
>Paul.
You can store files in the memo or memo/binary field in foxpro table using Filetostr() function and Replace command. Strtofile() function can write it back to file. Be advised that memo files are prone to bloat and corruption. If you've a lot of big files than you can soon reach 2Gb limit.
Another solution would be to store the files in the separate directory or directories and keep only full name of the files in the foxpro table.
--sb--