In SQL Server string constants use single quotes. I think MySQL is probably the same. Single quote should be safer. Also, use p and s instead of a/b for aliases.
>Martina,
>
>
- Check if table SUPPLIER contain field DESCRIPTOR
>- for string constants use '' instead ""
>- run the same SELECT in MySQL SQL Browse
>>
>- Supplier contains the field DESCRIPTOR.
>- Do you mean use single quotes instead of double quotes? WHY?
>- I ran this in MySQL Query Browser. It works. In VFP side, it will first display the error message I have shown, but continue on to display the correct results!
>
>Dennis
>
>
>
>
>>
>>SELECT A.REFNO, A.DATE, A.SUPPLIERID, A.TERMS, A.TOTQTY, A.AMOUNT, A.REMARKS,
>> A.PREPAREDBY, A.CHECKEDBY, A.PRINTDATE, A.POSTDATE, A.CLOSED, A.CANCELLED, A.ID,
>> B.CODE AS SUPPCODE, B.DESCRIPTOR AS SUPPNAME, B.ADDRESS AS SUPPADDR
>>FROM pohdr A JOIN SUPPLIER B ON A.SUPPLIERID=B.ID WHERE B.DESCRIPTOR LIKE "ABC%"
>>ORDER BY REFNO
>>
>>
>>MartinaJ
>>
>>>Dear Experts,
>>>
>>>What is wrong with this SQL statement?
>>>
>>>SELECT A.REFNO, A.DATE, A.SUPPLIERID, A.TERMS, A.TOTQTY, A.AMOUNT, A.REMARKS,
>>> A.PREPAREDBY, A.CHECKEDBY, A.PRINTDATE, A.POSTDATE, A.CLOSED, A.CANCELLED, A.ID,
>>> B.CODE AS SUPPCODE, B.DESCRIPTOR AS SUPPNAME, B.ADDRESS AS SUPPADDR
>>>FROM pohdr A JOIN SUPPLIER B ON A.SUPPLIERID=B.ID WHERE B.DESCRIPTOR LIKE "ABC%"
>>>ORDER BY REFNO
>>>
>>>
>>>If I placed exactly the same statement in MySQL Query Browser, it works. If I use it as my SelectCmd in a CursorAdapter, it generates this error, but gets the right result!
>>>
>>>
Connectivity error: [MySQL][ODBC 3.51 Driver][mysqld-5.1.52-community]Unknown column 'B.DESCRIPTOR' in 'where clause'>>>
>>>Help!
>>>
>>>Dennis
If it's not broken, fix it until it is.
My Blog