Can we build SPT using the SQLEXEC(x,SELECT...,) that has multi join conditions on the WHERE?

I created many WHERE conditions within a Remote View & wanted to paste the SQL into a .prg to use with SPT. I have a smaller sample of code below...it has a WHERE AND
I've tried many times with different multi-conditions but it doesn't work. It works fine with a single WHERE but when I add an "ADD", my SPT .prg won't work? (should be some syntax issue...?)

Is anyone getting this to work? Any examples? Yes, I'm new to SPT but I haven't had this problem on my other non-SPT SQL. Any ideas?

Thanks...


LOCAL lnhandle
lnhandle = SQLCONNECT("Fnxpro1")

SQLEXEC (lnhandle,"SELECT Fltrade.TRCUS, Fltrade.TRTAM, Fltrade.TRTDTE, Fltrade.TRCAM,;
Fltrade.TRCSQ, Fltrade.TRCPC, Fltrade.TRCNF, Fltrade.TRDST, Fltrade.TRCAT,;
Fltrade.TRRAN, Fltrade.TRPDTE;
FROM FUNDLINX.FLTRADE Fltrade;
WHERE {fn month(Fltrade.trtdte)} >= ?ccMonth;
AND Fltrade.TRCAT <> 'VARIC'")