Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Weird MySQL Behavior
Message
De
15/02/2011 03:24:06
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Weird MySQL Behavior
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Network:
Windows 2003 Server
Database:
MySQL
Application:
Desktop
Divers
Thread ID:
01500180
Message ID:
01500180
Vues:
135
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
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform