Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
BUG: CALCULATE COUNT(expression) uses SUM check
Message
From
12/02/2005 12:40:30
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
BUG: CALCULATE COUNT(expression) uses SUM check
Environment versions
Visual FoxPro:
VFP 9
Miscellaneous
Thread ID:
00986300
Message ID:
00986300
Views:
55
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
Reply
Map
View

Click here to load this message in the networking platform