Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Adding JPG files to the General Field
Message
From
01/03/2005 15:26:28
 
 
To
01/03/2005 15:09:54
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 6
OS:
Windows Millenium
Database:
Visual FoxPro
Miscellaneous
Thread ID:
00991734
Message ID:
00991748
Views:
18
>General fields have three major problems: 1) They take up much, much, much more space than the JPG file. 2) Because of problem #1, you can easily go beyond the limit of 2 GB for VFP-files. 3) It is very difficult to get the images back out of the General field.
>
>The usual recommendation is to keep the JPG as a separate file; then create a small character or memo field which contains the filename.


Entirely correct. Until VFP9, where now we can use BLOB type fields to store binaries. So now we CAN store images in DBFs if we want. Or we can keep doing it the previous way, e.g. storing only the path+filename reference, which is good advice.


Alex Feldstein, MCP, Microsoft MVP
VFP Tips: English - Spanish
Website - Blog - Photo Gallery


"Once again, we come to the Holiday Season, a deeply religious time that each of us observes, in his own way, by going to the mall of his choice." -- Dave Barry
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform