Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
PDF's on a Database
Message
De
11/06/2005 18:17:32
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivie
 
 
À
11/06/2005 18:07:15
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
01022516
Message ID:
01022524
Vues:
11
>Sorry If I sound such a newbie but I just dont know how this is done.
>I though the by goinig all those PDF's files on a database it would be a lot more esear if in the future I decide to do it on a Webapp or a normal windowsapp.
>But right now Im stuck on how to put them in a database.
>
>Thanks for all your help.

The idea is to have a table with documents. The PDF (or other) files themselves can either (a) be saved in a memo binary or BLOB, or (b) be kept as separate files, and only the filename in the table. In this latter case, you will have less problems of approaching the 2 GB limit in VFP (assuming you use DBF tables).

The table can have additional fields, like keywords, author, date, etc., to make it possible to search (it would be difficult and slow to search within the PDF themselves).

In case you use a memo binary field, for example, you can get the files in and out of the field with StrToFile() and FileToStr().
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform