Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
CHR(13) and EXECSCRIPT() error
Message
De
19/09/2005 09:16:05
 
 
À
19/09/2005 08:32:49
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:
01050830
Vues:
16
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform