Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Apostrophe in 'Create View' Statement
Message
 
 
À
25/08/2004 23:58:51
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00936451
Message ID:
00936578
Vues:
21
You can also do this which may be easier to maintain:
TEXT TO lcSQL NOSHOW PRETEXT 1
   Create sql view lv_cust as
   Select * from customer 
   where cust_id = ?cCust_ID
ENDTEXT
*!* A new pretext option in VFP9 eliminates this next step
lcSQL = strtran(lcSQL, CHR(13) + CHR(10), [ ])
&lcSQL

cCust_ID = [BERG'S]
USE lv_Cust
You can use TEXTMERGE in the TEXT TO as well if you need to include VFP functions, variable values, etc.

>Sergey, as always, thanks.
>
>I guess I'll just have to switch my delimiters and use [] for the overall statement delimiters and "" for the inside delimiters as I build the statement. Only mildly annoying I guess.
>
>Alan
Mark McCasland
Midlothian, TX USA
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform