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.
>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.