Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
CHR(13) and EXECSCRIPT() error
Message
From
19/09/2005 09:16:05
 
 
To
19/09/2005 08:32:49
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:
01050830
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform