Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Apostrophe in 'Create View' Statement
Message
 
 
To
25/08/2004 23:58:51
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00936451
Message ID:
00936578
Views:
20
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform