>
>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'>
What happens if you don't rename descriptor into suppname ?
I'm always chicken on single letter alias less than m. from the old dbase alias schema...
As this is supposed to work inside MySQL it should be no problem, but try with 2 letter alias IAC...
HTH
thomas