Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Sql as text
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
Visual FoxPro
Divers
Thread ID:
01216805
Message ID:
01216861
Vues:
11
>Just a correction, I know that you can't check it right now but VFP9 extends the PRETEXT flag, that way you can have a command w/o need to STRTRAN() it after that:
>
>  text to lcSelect noshow PRETEXT 15
>       Select bp_eng.engkod, bp_ten.t_szam, bp_ten.tcs_szam,
>              bp_ten.tipus, bp_ten.suly, bp_ten.ttav, bp_ten.kszam, bp_ten.ktav
>       From bp_eng
>       LEFT JOIN bp_ten ON ALLTRIM(bp_eng.engkod) ==  ALLTRIM(bp_ten.engkod)
>       Where bp_eng.engkod == "UE00000106"
>       into cursor temp2
>endtext
>? lcSelect
>
>
>PRETEXT expressions are:
>
>1  Eliminate spaces before each line.
>2  Eliminate tabs before each line.
>4  Eliminate carriage returns, for example, blank lines, before each line.
>8  Eliminate line feeds. && New in VFP9
>
>

Right, thanks. Still need to remove ; if we use the original code, though, and want to be able to run this select in command window first.
If it's not broken, fix it until it is.


My Blog
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform