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

Click here to load this message in the networking platform