lcSQL='SELECT Numero FROM News WHERE Year='+ALLTRIM(STR(lnYear)) &lcSQLSo, this allows me to pass lcSQL as a parameter and have it working in another method. Otherwise, if I would do:
lcSQL='SELECT Numero FROM News WHERE Year=lnYear
&lcSQL
I would need to have lnYear visible in the method.lcSQL='SELECT Numero FROM News WHERE StartDate=CTOD('01/01/1999')
&lcSQL
This won't be.