Dear All,
I was trying to build a ListBox using SQL Statement - 4. I build a complex query, the following is the query I tried,
*******
THISFORMSET.FRM_SN.SN_LIST.ROWSOURCE="SELECT SN_NO FROM SALENOTE INTO CURSOR SN_CURS1 WHERE M $ SN_NO OR M $ SN_CUSTNM OR M $ SN_CUST OR M $ SN_CADD OR M $ SN_CBNK OR M $ SN_CBNKADD OR M $ SN_PRCTRM OR M $ SN_PAYTRM OR M $ SN_CUSTNM OR M $ SN_ORIGIN OR M $ SN_LOAD OR M $ SN_DISCHG OR M $ SN_DESTN OR M $ SN_REMARK OR M $ SN_LCNO OR M $ SN_CUSTCD OR M $ SN_CO OR M $ SN_DEPT OR M $ SN_USER OR M $ CUSERNM OR M $ SN_CARRIER OR M $ SN_VSSL OR M $ SN_AGCODE OR M $ SN_OFC OR M $ SN_CITY OR M $ SN_CTRY OR M $ SN_REG OR SN_NO IN (SELECT SN_NO FROM SNITEMDATA WHERE M $ SN_ITMNO OR M $ SN_ITMDES OR M $ SN_SUPITM OR M $ SN_CUSORD OR M $ SN_CUSITM OR M $ SN_CARTON OR M $ SN_MARKS)"
********
But it gave error "Command contains unrecognised phrase/keyword". I tested the SQL statement its correct, the Object reference is also correct, RowSourceType property is also correctly set to 3.
Can somebody explain this behaviour of VFP???
Regards
Shaishav