Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
CHR(13) causing previous values to disappear
Message
De
13/07/2004 11:43:09
Jay Johengen
Altamahaw-Ossipee, Caroline du Nord, États-Unis
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00923708
Message ID:
00923779
Vues:
34
Doh!

I'm not carrying over the value from record to record. All I need is a variable to store it to.

Double doh!

>Showing it where? Your replace command seems somewhat at odds with what you are saying you want to do. The replace will replace each row with the content of it's own header1. It won't be concatenating header1's together.
>
>>Very interesting. That solves the problem in the command window using variables, but the memo field is still only showing the last value.
>>
>>>Jay,
>>>
>>>It's a display time thing. Your values are overwriting each other because you only issue a carriage return. If you add a linefeed you should see what you are expecting.
>>>
>>>
>>>SCAN
>>>   REPLACE Header1Text WITH Header1Text + ALLTRIM(Header1) + CHR(13) + chr(10)
>>>ENDSCAN
>>>
>>>
>>>>Let's say there are 3 records in the open table and the values of Header1 are all different. If I use "CHR(13)" then I only get the last value of Header1 in the Header1Text field. If I use a character, like "|" then I get all three values concantenated together separated by the "|" character. Why am I losing the first two values when I use "CHR(13)?" I can also duplicate this behavior in the command window using variables.
>>>>
>>>>
>>>>SCAN
>>>>   REPLACE Header1Text WITH Header1Text + ALLTRIM(Header1) + CHR(13)
>>>>ENDSCAN
>>>>
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform