[V4WS] COUNT(*) and RecID problem
Solon Morse
solon at mail.enaturalist.org
Mon Jul 21 13:13:35 CDT 2003
I cannot select recid's if I use the COUNT(*) function -- V4WS 1.9.7
example:
SELECT
cities.RecID,
states.state,
cities.city,
COUNT(*)
FROM
states,
cities,
accomodations
GROUP BY
city
ORDER BY
state
The returned cursor doesn't contain a recid column but the data in the
"state" column contains the recid's, the "cities" column contains the
"states" column data, and the COUNT(*) column contains only zeroes, like
this:
state city count(*)
----- ----- -----
1 New York 0
rather than this:
recid state city count(*)
----- ----- ----- -----
1 New York Ashville 1
I saw this problem mentioned some time ago for V4RB -- has it been fixed in
the latest betas?
Thanks,
Solon Morse
More information about the Valentina
mailing list