https://community.graphisoft.com/t5/Project-data-BIM/ArchiCAD-and-SQL/m-p/7633#M14152 <DIV class="actalk-migrated-content"> <BLOCKQUOTE>vannassen wrote:<BR />hi,<BR />i'm trying to use sql for making queries to the database, but i can't quite figure out what sql-statements it understands and which ones i doesn't. does anybody have a clue or is i documentet somewhere?<BR />regards,<BR />vannassen</BLOCKQUOTE> The available tables and fields are fully documented, but the version of SQL is not. I had asked GS tech support about this once and was simply told it was 'standard' SQL and given no further information. Of course, there are many dialects and so we are on our own it seems to determine the exact syntax allowed.<BR /><BR />The following post with some sample code might help you:<BR /><A href="http://www.graphisoft.com/community/archicad-talk/viewtopic.php?p=6914#6914" target="_blank" rel="noopener">http://www.graphisoft.com/community/archicad-talk/viewtopic.php?p=6914#6914</A><BR /><BR />I used to know other versions of SQL, but after having used Microsoft Access for so many years, that's the only version I know these days ... and the FLAT keyword was new to me. The other syntax in the linked example might be enough for you to extrapolate your SQL knowledge to retrieve what you want.<BR /><BR />Post some examples for others ... of things that don't work, and we'll see if we can figure them out jointly ... or of things that work that people can use Cookbook-style like my tip above. It seems that very few people are using this feature.<BR /><BR />Cheers,<BR />Karl</DIV> Mon, 03 Feb 2025 16:44:46 GMT Karl Ottenstein 2025-02-03T16:44:46Z https://community.graphisoft.com/t5/Project-data-BIM/ArchiCAD-and-SQL/m-p/7633#M14152 <DIV class="actalk-migrated-content"> <BLOCKQUOTE>vannassen wrote:<BR />hi,<BR />i'm trying to use sql for making queries to the database, but i can't quite figure out what sql-statements it understands and which ones i doesn't. does anybody have a clue or is i documentet somewhere?<BR />regards,<BR />vannassen</BLOCKQUOTE> The available tables and fields are fully documented, but the version of SQL is not. I had asked GS tech support about this once and was simply told it was 'standard' SQL and given no further information. Of course, there are many dialects and so we are on our own it seems to determine the exact syntax allowed.<BR /><BR />The following post with some sample code might help you:<BR /><A href="http://www.graphisoft.com/community/archicad-talk/viewtopic.php?p=6914#6914" target="_blank" rel="noopener">http://www.graphisoft.com/community/archicad-talk/viewtopic.php?p=6914#6914</A><BR /><BR />I used to know other versions of SQL, but after having used Microsoft Access for so many years, that's the only version I know these days ... and the FLAT keyword was new to me. The other syntax in the linked example might be enough for you to extrapolate your SQL knowledge to retrieve what you want.<BR /><BR />Post some examples for others ... of things that don't work, and we'll see if we can figure them out jointly ... or of things that work that people can use Cookbook-style like my tip above. It seems that very few people are using this feature.<BR /><BR />Cheers,<BR />Karl</DIV> Mon, 03 Feb 2025 16:44:46 GMT https://community.graphisoft.com/t5/Project-data-BIM/ArchiCAD-and-SQL/m-p/7633#M14152 Karl Ottenstein 2025-02-03T16:44:46Z