Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
CHR(13) and EXECSCRIPT() error
Message
From
19/09/2005 10:07:13
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
 
To
19/09/2005 09:16:05
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP SP1
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01050807
Message ID:
01050849
Views:
10
>Fabio
>Thanks for your reply.
>
>>You cannot put a CHR(13) into a literal string.
>So I've discovered.
>
>>Uses a binary:
>>lcFldVal2 = "Line 1" + 0hD + "Line 2"
>Never thought of using binary.
>
>To make it work I've had to use CREATEBINARY()
>lcFldVal2 = ["Line 1" + CREATEBINARY(CHR(13)) + "Line 2"]
>Is this what you meant?
>
>
>>Why to use a EXECSCRIPT for this simple task ?
>>Direct syntax is more efficient:
>>fieldName1 = "cText"
>>fieldName1 = "mText"
>>INSERT INTO (lcTbl) ((fieldName1),(m.fieldName2) VALUES (lcFldVal1,lcFldVal2)
>Point taken.
>
>Gordon

What is wrong with:
lcFldVal2 = ["Line 1" + CHR(13) + "Line 2"]
or you might:
text to m.lcFldVal2 noshow
Line 1
Line 2
Line 3
endtext
PS:Do not insist on ExecScript for this or it'd catch you sooner or later.
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