Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Strtran
Message
 
À
15/10/2008 05:26:00
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP
Network:
Windows XP
Database:
Visual FoxPro
Divers
Thread ID:
01355061
Message ID:
01355194
Vues:
29
>>>Hi all,
>>>Could you help me what I've done wrong.
>>>I have a memo field and would like to get rid of the characters of CHR(13) and CHR(10) from the field.
>>>I use the function STRTRAN() like this STRTRAN(CHR(13)+CHR(10), mymemofield) but it doesn't seem to work.
>>>Any help would be appreciated.
>>>
>>>Tamas
>>
>>You reversed parameters it should be:
>>
>>? STRTRAN(MyMemo,CHR(13)+CHR(10),[])
>>
>
>
>Yes, you're right, I mixed it up in the text here but I used it correctly within VFP.
>I used like this:
>
>
>lfcr = CHR(13)+CHR(10)
>? occurs(lfcr,tetel2.utvonal)
>STRTRAN(tetel2.utvonal,lfcr,[])
>? occurs(lfcr,tetel2.utvonal)
>
>
>Both result 4. So it runs without doing the job.
>Tamas

Tamas,
STRTRAN() is a function and it returns a result.
It didn't change the value of the string you passed (no matter variable or Field). So you must use the result for your further jobs REPLACE (as Kevin already point) or something else.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform