Hi Borislav,

Yes I had forgotten about it. ha ha ha.. It's been 8 months that Im using Delphi and it makes me forget my good old friend VFP. So easy to forget? :) I shouldn't be.

Anyway, many thanks.

Regards,

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