topic Re: GROUP BY in sql query in Archicad C++ API

GROUP BY in sql query

Anonymous — Tue, 06 Dec 2022 12:59:45 GMT

Hello !

Try to create some simple query.
I need to sum some parametrs and use GROUP by command
But when I try to execute - fail.

unexpected token: GROUP в [строка: 1, столбец: 70]

My query:

select h.PARAMETERS.name   from flat( OBJECTS,PARAMETERS) as h 
group by h.PARAMETERS.name

It is working?

And one more question.
How I can storage queries in project ?

Re: GROUP BY in sql query

Mihaly Palenik — Fri, 15 Sep 2017 15:06:28 GMT

Hello,

maurice72 wrote:
I need to sum some parametrs and use GROUP by command
But when I try to execute - fail.

as Ákos Somorjai said in this topic (archicad-talk.graphisoft.com/viewtopic.php?t=57029),
the SQL queries are not supported any more officially (the last supported version was ARCHICAD 18 ), so don't rely on them.

maurice72 wrote:
How I can storage queries in project ?

Could you explain exactly what would you like to store in project file? Just the string of queries or something else?

Best,
Mihály