| Subject | Things that works in versio 1.5 and dont works in 2.0 |
|---|---|
| Author | Marco Castroo |
| Post date | 2006-11-28T10:55:35Z |
Hi,
In FireBird 1.5 I have a query with a group like this
...
Group by ae.Author, l.Book, Price,
case
When op.StockChange in (23,24) Then 21
When op.StockChange in (43,44) Then 22
Else Mode end
...
It works in 1.5 but raises an error in 2.0. Any idea how to work
around this? The exception is: Cannot use an aggregate function in
GROUP BY clause.
Thanks,
Marco Castro
In FireBird 1.5 I have a query with a group like this
...
Group by ae.Author, l.Book, Price,
case
When op.StockChange in (23,24) Then 21
When op.StockChange in (43,44) Then 22
Else Mode end
...
It works in 1.5 but raises an error in 2.0. Any idea how to work
around this? The exception is: Cannot use an aggregate function in
GROUP BY clause.
Thanks,
Marco Castro