Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Adding JPG files to the General Field
Message
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:
00991754
Views:
14
>>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,
I agree in VFP9 with BLOB is easily.
_______________________________________________________________
Testing displays the presence, not the absence of bugs.
If a software application has to be designed, it has to be designed correctly!
_______________________________________________________________
Vladimir Zografski
Systems Analyst
Previous
Reply
Map
View

Click here to load this message in the networking platform