Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
CHR(13) causing previous values to disappear
Message
 
 
To
13/07/2004 11:25:58
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:
00923770
Views:
33
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform