SQLSETPROP(lnHandle, [Asynchronous],.f.) TEXT TO lcSQL NOSHOW PRETEXT 15 SELECT TAlias1.PIF_NAME, TAlias2.PIF_ID FROM CLIENTS TAlias1 INNER JOIN PAYMENTS TAlias2 ON TAlias1.PIF_ID = TAlias2.PIF_ID ENDTEXT IF SQLEXEC(lnHandle, lcSQL , "CPAY") < 0 AERROR(laError) MessageBox(laError[1,2]) ENDIFAnother one.. this one works
TEXT TO lcSQL NOSHOW PRETEXT 15 Select * from "Pay Batch" WHERE RTRIM(Month)= 'June' AND YEAR = 2007 ENDTEXTThis one not
xMonth = 'June' xYear = 2007 TEXT TO lcSQL NOSHOW PRETEXT 15 Select * from "Pay Batch" WHERE RTRIM(Month)= xMonth AND YEAR = xYear ENDTEXTError with Connectivity Error [...]To few parameters. expected 2
>SQLSETPROP(lnHandle, [Asynchronous],.f.) > >TEXT TO lcSQL NOSHOW PRETEXT 15 > SELECT TAlias1.PIF_NAME, > TAlias2.PIF_ID > FROM CLIENTS TAlias1 > INNER JOIN PAYMENTS TAlias2 ON TAlias1.PIF_ID = TAlias2.PIF_ID >ENDTEXT >IF SQLEXEC(lnHandle, lcSQL , "CPAY") < 0 > AERROR(laError) > MessageBox(laError[1,2]) >ENDIF >