cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 
2024 Technology Preview Program

2024 Technology Preview Program:
Master powerful new features and shape the latest BIM-enabled innovations

Collaboration with other software
About model and data exchange with 3rd party solutions: Revit, Solibri, dRofus, Bluebeam, structural analysis solutions, and IFC, BCF and DXF/DWG-based exchange, etc.

SQL query to AC 16

Anonymous
Not applicable
Good day! Prompt.
I need to perform SQL queries in the project file ArchiCAD 16
Need loading a table with the roof (X, Y, Z).
There is information that this is likely to do with the ODBC driver.
I am developing program on C#

questions:
Can anyone do such a thing? tell me and showing this.
How it can work here ODBC driver if you can throw off the literature or links
In google information plainly absent.
2 REPLIES 2
Karl Ottenstein
Moderator
Hi,

Please clarify:

Are you trying to retrieve data from the model with the existing Graphisoft ODBC driver as a pure ODBC client? Or, are you trying in C# to develop an add-on (plug-in) which obtains the xyz coordinates of the roof planes?

(Note: the ODBC access to the model is read-only - you can only retrieve the limited data allowed in the schema - you cannot change any model data.)

If pure ODBC client, I do not believe there is any access to any coordinate (xyz) information anyway... use the Show Data Structure command to obtain the list of tables that is exposed by the ODBC (and built-in SQL) driver. I may have missed it, but do not see any coordinate information.

If you require xyz coordinates... then you probably have to write an add-on (which would have access to more model data)... and export what you want from your add-on (plug-in). That cannot be written in C# though, but in C / C++ using the API developer kit. If that's what you're after, I'll move this thread into the Developer forum.

Karl
Screen Shot 2012-10-15 at 11.14.47 AM.png
One of the forum moderators
AC 27 USA and earlier   •   macOS Ventura 13.6.7, MacBook Pro M2 Max 12CPU/30GPU cores, 32GB
Anonymous
Not applicable
Me need to take the coordinats of the roof in model (xyz) and all its components (junctions, ranges ...).
I'm trying learn how to do it.
I was told that most likely can be queried in the AC model with ODBC driver.
I try to do this with C # because I know him better.
I opened the file AC with ODBC driver in the program MS Access. And found table "roof".
There's a lot of data, I thought one of them is the position, is not it?