[V4Rb] Error 346

[Ruslan Zasukhin]

on 12/9/03 12:18 AM, Charles Yeomans at yeomans at desuetude.com wrote:

> The query
> 
> SELECT Matters.RecID, Matters.matter_name,
> SUM(TimeEntries.time_worked) FROM Matters, TimeEntries GROUP BY
> Matters.matter_name
> 
> results in error 346, "field name not unique", and it appears that the
> inclusion of the Matters.RecID field is the cause.  I'm using the
> current V4Rb beta.

Hi Charles,

Actually this must be other error code:

    It is WRONG to use in SELECT fields that are not in GROUP BY.

You see mistake?


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