>TEXT TO lcSQL NOSHOW PRETEXT 15 > Select * from "Pay Batch" WHERE RTRIM(Month)= 'June' AND YEAR = 2007 >ENDTEXT >>
>xMonth = 'June' >xYear = 2007 >TEXT TO lcSQL NOSHOW PRETEXT 15 > Select * from "Pay Batch" WHERE RTRIM(Month)= xMonth AND YEAR = xYear >ENDTEXT >You must use parameters for this:
xMonth = 'June' xYear = 2007 TEXT TO lcSQL NOSHOW PRETEXT 15 Select * from "Pay Batch" WHERE RTRIM(Month)= ?xMonth AND YEAR = ?xYear ENDTEXT