Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Inserting data in a blob field
Message
De
18/05/2005 02:25:49
 
 
À
17/05/2005 17:32:37
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9
OS:
Windows XP
Database:
Visual FoxPro
Divers
Thread ID:
01014882
Message ID:
01015209
Vues:
18
>>>>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.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform