>Another one.. this one works
>
>TEXT TO lcSQL NOSHOW PRETEXT 15
> Select * from "Pay Batch" WHERE RTRIM(Month)= 'June' AND YEAR = 2007
>ENDTEXT
>
>
>This one not
>
>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
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
