>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'>
I'd guess nothing wrong with the statement but something wrong with the driver?
Or is it possible the DESCRIPTOR is a reserved word in the ODBC ?