GDL object + SQL

Home Forums Problems and solutions in GDL Others GDL object + SQL

This topic contains 3 replies, has 2 voices, and was last updated by  Joachim Sühlo 1 week, 2 days ago.

  • Author
    Posts
  • #3528

    Matthias Weinlich
    Participant

    HI
    I want to use SQL to export a list of data without having to make a spreadsheet every time.
    I asked for “SELECT LIBRARY_PART_NAME, parameters FROM objects” ->works fine, but as soon as i want to look for just one parameter f.e. “NAME”
    “SELECT P.Library_part_name , OP.name FROM Objects P, objects.parameters OP”
    I get an error: unexpected token

    Can you help me with the right syntax?

    AC 20, Win 7, mac

  • #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

  • #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

  • #3550

    Joachim Sühlo
    Participant

    I have a document named “Graphisoft SQL Language Reference”, which I could send to you.

    GDL Object Developer
    b-prisma
    MAC OSx 10.11

You must be logged in to reply to this topic.