Studio Crash on SQL query

[Ruslan Zasukhin]

On 18.10.2006 22:19, "Balestrieri, John" <jbalestrieri at ap.org> wrote:

Hi John,

Please report this into Mantis,
    attach small db and this query.

> The enclosed SELECT is crashing Valentina Studio on my database (valentina
> unexpectedly quits). If I omit the column Results.FocusParty there's no crash.
> Results.FocusPart is a calculation field:  if(party='GOP' or
> party='Dem',party,'Other')
> 
> Performing a SELECT on just Results.FocusParty is fine... no crash, and the
> correct results are being returned. Not performing any aggregate
> functions/grouping is also OK -- no crash. I'm going to run this query in Rb
> and see what happens now...
> 
> John
> 
> ------
> 
> SELECT
> Race.CountyName,
> Results.FocusParty,
>         Sum(Results.VoteCount) AS 'VoteTally',
>         Sum(Race.PrecinctsReporting) AS 'PrecinctTally',
>         Sum(Race.TotalPrecincts) AS 'PrecinctTotal'
> 
> FROM 
>         Results,
>         Race
>        
> WHERE
>         Race.RaceCountyID = Results.RaceCountyID
> AND Results.Meta_State = 'CA' --State postal
> AND Race.OfficeID = 'G' --Office
> 
> 
> GROUP BY
> Race.CountyName,
> Results.FocusParty
> 
> ORDER BY
> Race.CountyName,
>         VoteTally DESC

-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]