>Hi All:
>
>My client wants to associate JPG, XLS and DOC files with his customer database. I was thinking of storing the name in a field and then invoking the right program via office automation when he requests it. Any references that anyone can point me to in helping me with this project?
>
>As far as I know, a GENERAL field only handles pictures. Is this right?
>
>Thanks,
>
>Yossi
General is very problematic - not because it handles only pictures, but because it is very hard to get things out of it. Also because the size of the DBT (memo) file will increase much faster than the contents stored.
Even if you use a BLOB field, you might quickly reach the Visual FoxPro limit of 2 GB per file, so storing only the filenames is the only sensible thing to do.
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)