[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