Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Combine char field with memo, output to memo
Message
From
20/11/2001 12:53:57
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
 
To
20/11/2001 12:52:03
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00584026
Message ID:
00584064
Views:
35
>>I'm trying to re-structure a table that has a 254-byte notes field and a memo comments field. I need to combine these two into one memo field, IE:
>>
>>lmNewMemo = lcOldCharField + Chr(13)+ Chr(10) + lmOldMemoField
>>
>>The "lmNewMemo" field contains just the old memo field.
>>
>>Any suggestions?
>>
>>Thanks,
>>
>>Harry
>
>Harry,
>Try :
>replace lmNewMemo with lcOldCharField + Chr(13)+ Chr(10) + lmOldMemoField
>
>Cetin
BTW they're not actual field names I think :

replace (lmNewMemo) with eval(lcOldCharField) + ;
Chr(13)+ Chr(10) + eval(lmOldMemoField)

Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Reply
Map
View

Click here to load this message in the networking platform