Archicad C++ API
About Archicad add-on development using the C++ API.

GROUP BY in sql query

Anonymous
Not applicable
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 ?
1 REPLY 1
Mihaly Palenik
Graphisoft
Graphisoft
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