| Subject | Firebird 2.5 any known issues with "MAX" keyword |
|---|---|
| Author | Craig Cox |
| Post date | 2012-10-17T16:00:53Z |
The following SQL statement works in IB Expert against a FB 2.5 database, but results in an error when I try to use the statement through an IB Objects query (Ver 4.9.143)
SELECT MAX(Transfer_PK) as MaxVal
FROM Transfer
The error is:
ISC Error Code 335544569
Dynamic SQL error
SQL error code = @1
Invalid expression in the @1(not contained in either an aggregate function or the GROUP BY clause)
SELECT MAX(Transfer_PK) as MaxVal
FROM Transfer
The error is:
ISC Error Code 335544569
Dynamic SQL error
SQL error code = @1
Invalid expression in the @1(not contained in either an aggregate function or the GROUP BY clause)