Base sql staus 37000 error code -67 [closed]

asked 2014-09-09 19:01:56 +0200

Mindofbeholder gravatar image

This error comes up any time I try to group query results.

Here is my setup. image description

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2016-03-03 17:19:28.915131


The error code (67 for HSQL v1.8) is labelled NOT_IN_AGGREGATE_OR_GROUP_BY so presumably there is something wrong with the manner in which you are trying to group. I will leave it to a Base expert to provide an answer.

oweng gravatar imageoweng ( 2014-09-10 05:51:08 +0200 )edit

Try adding aggregate functions to all of the columns. The way query is written now, if there is one value in eventTitle, and multiple in any of the other fields, query does not provide instruction of what value you want returned for other fields. MySQL would return only the first value in those columns, not display other values, which is not always obvious. Possibly HSQL returns an error instead?

doug gravatar imagedoug ( 2014-09-12 18:05:33 +0200 )edit