Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
BUG: CALCULATE COUNT(expression) uses SUM check
Message
De
12/02/2005 12:40:30
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
BUG: CALCULATE COUNT(expression) uses SUM check
Versions des environnements
Visual FoxPro:
VFP 9
Divers
Thread ID:
00986300
Message ID:
00986300
Vues:
56
On next code you can see that
on dbbase command CALCULATE COUNT(expression)
( CALCULATE is 4 X faster respect to a SELECT !)
is correct when expression is a numeric,
for a not numeric expression, it fire a error
CREATE CURSOR aaa ( ax i NULL,ay L NULL)
INSERT INTO aaa values(NULL,NULL)
INSERT INTO aaa values(0,.F.)
CALCULATE COUNT(AX) TO SS
? SS && 1, as it must be
* next fire a sum error
CALCULATE COUNT(AY) TO SS
Répondre
Fil
Voir

Click here to load this message in the networking platform