Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
CHR(13) causing previous values to disappear
Message
 
 
To
13/07/2004 10:14:14
Jay Johengen
Altamahaw-Ossipee, North Carolina, United States
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00923708
Message ID:
00923730
Views:
21
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform