Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
PDF's on a Database
Message
From
11/06/2005 18:17:32
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
 
 
To
11/06/2005 18:07:15
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01022516
Message ID:
01022524
Views:
10
>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)
Previous
Reply
Map
View

Click here to load this message in the networking platform