Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Inserting data in a blob field
Message
From
18/05/2005 02:25:49
 
 
To
17/05/2005 17:32:37
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01014882
Message ID:
01015209
Views:
17
>>>>Hi Sergey. Whats the difference between blob and binary memo field in VFP9? Seems the same to me?
>>>
>>>Besides Sergey's answer, a BLOB field nicely solves the problem of storing images (or other binary data) in a DBF, avoiding the dreaded MEMO GENERAL fields.
>>
>>But presumably not avoiding memo file bloat :) Havent had a chance to play with it yet :)

>
>
>Nope. Memo's by definition work on blocks. They reserve the block size even if you pass the size by one byte, a whole new block is spent. Then when you delete a record and re-change it, a new set of memo blocks are reserved, therefore bloat. But you already knew this. Memo bloat has not changed. What has changed is that with BLOBs, which resolve to text, you get to use regular memos not General, which bloat rate is insane.

Yeah, I realised this. It's in the nature of fpt files. But thats ok - we all have our work-arounds :)
In the End, we will remember not the words of our enemies, but the silence of our friends - Martin Luther King, Jr.
Previous
Reply
Map
View

Click here to load this message in the networking platform