[V4Rb] Error 346

[Ruslan Zasukhin]

on 12/9/03 8:22 PM, Charles Yeomans at yeomans at desuetude.com wrote:

>> Again, this is not Valentina specific. This is STANDARD RULE.
>> 
> 
> And I believe it.  But what I am saying is that Valentina returns
> correct data for the query
> 
> SELECT
>    Matters.matter_name,
>    Matters.last_changed,           <<<<<<<<<< this is normal field.
>    SUM(TimeEntries.time_worked)
> FROM
>    Matters,
>    TimeEntries
> GROUP BY
>    Matters.matter_name
> 
> So is this a bug in Valentina?

Yes, glitch

BTW, Right now I work on 2.0 SQL nodes for AGGR funcs and group by to do
this correctly.


> And why does the following query fail with error 346?

I think this can be RecID specific problem.

You can try workaround -- make BaseObject method ULONG = recID.

>> SELECT
>>     Matters.recID,
>>     SUM(TimeEntries.time_worked)
>> FROM
>>     Matters,
>>     TimeEntries
>> GROUP BY
>>     Matters.recID

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