Matthias Weinlich

Forum Replies Created

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • in reply to: GDL object + SQL #3542
    Matthias Weinlich
    Participant

    grrr. does anyone has a documentation of usable SQL in Archicad? I tried to use Count and group.
    ” SELECT LIBRARY_PART_NAME, OP.PARAMETERS.NAME, COUNT (OP.PARAMETERS.VALUE) FROM FLAT (OBJECTS, PARAMETERS) AS OP
    WHERE LIBRARY_PART_NAME=’Arbeitsplatz 001′ AND OP.PARAMETERS.NAME =’MA 52′
    GROUP BY OP.PARAMETERS.NAME ”

    But it doesn’t work. Error ” the function COUNT is not defined ” OR ” unexpected token: GROUP ” Pleas help! I just want to have this short way to count different objects when I’m asked without the need of spreadsheets all the time!

    OR:
    Is there a way to export all generated data and put them into a database where I can use proper SQL? Maybe directly AC -> Database without an csv. in between….

    AC 20, Win 7, mac

    in reply to: GDL object + SQL #3540
    Matthias Weinlich
    Participant

    OK got it myself 😀

    SELECT OP.PARAMETERS.NAME, OP.PARAMETERS.VARIABLE_NAME, OP.PARAMETERS.TYPE, OP.PARAMETERS.VALUE FROM FLAT (OBJECTS, PARAMETERS) AS OP WHERE LIBRARY_PART_NAME=’Arbeitsplatz 001′

    AC 20, Win 7, mac

Viewing 2 posts - 1 through 2 (of 2 total)