Bug when grouping?

[ktrinad]

By: Ruben Misrahi - rnmisrahi

Bug when grouping?

2003-03-18 09:06

Using a simple query such as:

SELECT BRAND, STYLE, Sum(QUANTITY), Sum(COST)

FROM POS

Group by Brand, Style

 

Generates two variables with the name SUM, which can be corrected by Modifying the variable names.

The funny thing is that the first SUM variable is set as String. This can also be corrected.

Nevertheless, when I try to Compile the report I get InvalidArgumentException.

I'm using Interbase and this query works fine in any sql tool.

 

Any ideas?