Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
CURSOR Experiencing Memo Bloat
Message
De
19/07/2006 05:10:17
 
 
À
18/07/2006 14:26:24
Dragan Nedeljkovich (En ligne)
Now officially retired
Zrenjanin, Serbia
Information générale
Forum:
Visual FoxPro
Catégorie:
Problèmes
Divers
Thread ID:
01136610
Message ID:
01137523
Vues:
27
>>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?
>
>Basically, the idea is to never let it shrink; let it bloat only when its size exceeds the current max size for that one memo for that record.
>
>It's pretty much like
>
>replace mymemo with padr(newvalue, max(len(mymemo), len(newvalue)), chr(0))
>
>(or chr(32) if that fits your needs better)
>

Thanks Dragan. Using your simple
replace mymemo with padr(newvalue, max(len(mymemo), len(newvalue)), chr(0))
is very straight forward and makes for a neat solution. Thanks. I prefer the wild, moutain man picture <g>
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
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform