Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
CHR(13) causing previous values to disappear
Message
 
 
À
13/07/2004 11:25:58
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:
00923770
Vues:
32
This message has been marked as the solution to the initial question of the thread.
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
>>>
df (was a 10 time MVP)

df FoxPro website
FoxPro Wiki site online, editable knowledgebase
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform