Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
TEXTMERGE with variables
Message
 
 
To
05/07/2011 05:37:54
Victor Chignes
Inteliventas
Peru
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
01517278
Message ID:
01517279
Views:
124
This message has been marked as the solution to the initial question of the thread.
qp1 = "Lima"
Sql = "Select * from customer where city =  '<<qp1>>' "
? TEXTMERGE(sql)

*** Or

qp1 = "Lima"
TEXT TO lcSQL NOSHOW TEXTMERGE
Select * from customer where city =  '<<qp1>>'
ENDTEXT
>I'm trying to create a end user query generator. For that I need to let the user enter variables and then select statements using those variables.
>
>After that I have to create the final select statement.
>
>So far I have this:
>
>qp1 = "Lima"
>Sql = "Select * from customer where city =  '<<qp1>>' "
>TEXT TO lcSQL NOSHOW TEXTMERGE
>  <<Sqlt>>
>ENDTEXT
>?    lcSQL
>
> I was hoping to obtain "Select * from customer where city = 'Lima' " but I get
Select * from customer where city =  '<<qp1>>'
instead.
>
>Any help or equivalent approach?
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform