In a loop I use queries like: 'select * from REPORTS where PRID=50074 and RID!=PRID' -it's ok.
BUT when I try a sorted form: 'select * from REPORTS where PRID=50074 and RID!=PRID ORDER BY RID' I get exceptions:
java.sql.SQLException: Not contained in aggregate function or group by clause:
COLUMN REPORTS.RID
at org.hsqldb.jdbcDriver.sqlException(Unknown Source)
at org.hsqldb.jdbcStatement.fetchResult(Unknown Source)
at org.hsqldb.jdbcStatement.executeQuery(Unknown Source)!
...
Because the 1st one contains RID!=PRID I'd say table is ok (contains column RID)?
How can I get sorted results?
(using text-tables, index.html says: "hsqldb version 1.7.2 Alpha J Download")
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
In a loop I use queries like: 'select * from REPORTS where PRID=50074 and RID!=PRID' -it's ok.
BUT when I try a sorted form: 'select * from REPORTS where PRID=50074 and RID!=PRID ORDER BY RID' I get exceptions:
java.sql.SQLException: Not contained in aggregate function or group by clause:
COLUMN REPORTS.RID
at org.hsqldb.jdbcDriver.sqlException(Unknown Source)
at org.hsqldb.jdbcStatement.fetchResult(Unknown Source)
at org.hsqldb.jdbcStatement.executeQuery(Unknown Source)!
...
Because the 1st one contains RID!=PRID I'd say table is ok (contains column RID)?
How can I get sorted results?
(using text-tables, index.html says: "hsqldb version 1.7.2 Alpha J Download")