Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
CHR(13) and EXECSCRIPT() error
Message
De
19/09/2005 10:07:13
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
 
À
19/09/2005 09:16:05
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 9
OS:
Windows XP SP1
Database:
Visual FoxPro
Divers
Thread ID:
01050807
Message ID:
01050849
Vues:
17
>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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform