Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
General fileds
Message
From
31/05/2002 11:16:44
 
 
To
30/05/2002 09:30:20
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
00662410
Message ID:
00663480
Views:
20
>Now, apart from the memo bloat (reported by many other programmers, contradicted by your experiments), there is the other problem, that it is difficult to get pictures out of the general field.
>
>For those two reasons, most programmers here on the UT recommend using separate JPG-files (or GIF, or whatever).


Hilmar,

My "experiments" do not contradict the memo bloat issue. Memo bloat only happens if you replace memo field contents with new data. I am not doing that. If you store a JPG or other file in a general field there is no bloat problem unless you replace the image again and again.

Secondly, if you want to store images or other files in a VFP DBF then just use a binary memo field and not a general field and then its easy to get the file out again using COPY MEMO command.

General fields are not for storing files in but storing OLE objects in.

Besides, none of this has any further relevance to the original posting.

Jos
In the End, we will remember not the words of our enemies, but the silence of our friends - Martin Luther King, Jr.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform