Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Why does COUNT(*) via SPT yield a character field?
Message
De
06/11/2010 02:29:52
Dennis Lim
D-Labs, Inc.
Manila, Philippines
 
 
À
05/11/2010 06:32:15
Sergey Berezniker
New York, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Re: Why does COUNT(*) via SPT yield a character field?
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Network:
Windows 2003 Server
Database:
MySQL
Application:
Desktop
Divers
Thread ID:
01488353
Message ID:
01488431
Vues:
52
Sergey,

My guess is that mysql ODBC driver returns a data type for COUNT(*) that VFP cannot match to one of it numeric data types. First make sure that you have corect version of ODBC driver. If it doesn't help, try to cast result o an integer.

I am using MySQL ODBC 3.51 Driver. MySQL Server 5.1.52 (the latest right now).

Thanks
Dennis
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform