Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
CHR(13) causing previous values to disappear
Message
 
 
À
13/07/2004 10:14:14
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:
00923730
Vues:
22
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