Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Weird MySQL Behavior
Message
De
15/02/2011 08:50:13
 
 
À
15/02/2011 08:32:44
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
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:
01500230
Vues:
48
There are cases when the only solution is to ignore the error.

>Naomi,
>
>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.
>
>I have change my double quotes into single quotes, with the same (unwanted) result. Kindly check message 1500219 - I have also changed the table alias A and B into AA and BB as per Tore's advise. Still the same.
>
>Funny thing is, it works on the MySQL side. It also works on VFP side, but shows an error message (trapped by my code) first, then displays the correct results!
>
>Jeeezz!!
>
>Dennis
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform