Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Storing and retrieving files within VFP DB
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00617079
Message ID:
00617088
Views:
32
>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--
Previous
Reply
Map
View

Click here to load this message in the networking platform