[V4WS] COUNT(*) and RecID problem

[Ruslan Zasukhin]

on 7/21/03 20:13, Solon Morse at solon at mail.enaturalist.org wrote:

> 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?

It seems yes.

Try latest beta. 
Note, if it will not work, let me know, I will make new build.
I have see some mistake in one of V4WS builds.

-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------