Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
CURSOR Experiencing Memo Bloat
Message
De
18/07/2006 02:25:29
 
 
À
18/07/2006 00:33:47
Information générale
Forum:
Visual FoxPro
Catégorie:
Problèmes
Divers
Thread ID:
01136610
Message ID:
01137149
Vues:
20
>Hi David. pmfji - I have a file which does not get updated often, has only a few hundred records, but does contain a memo field which can hold a large amount of text, +/-5Mb. Just to be clear, are you saying that it might be beneficial to pad my text with chr(0) out to some maximum possible size and then to ensure that each replace always pads out to the same size? i.e. ensure that each memo field is always, for example, 6Mb in my case?
>

If the spaces are useless, then you can
* write
replace with PAD(,6M)

* read
? RTRIM(MEMO)
But only in exclusive mode and without buffering, this avoids the bloat.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform