Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Storing and retrieving files within VFP DB
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00617079
Message ID:
00617088
Vues:
35
>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--
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform