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

Questions to ArchiCAD ODBC driver 9.x

Anonymous
Not applicable
We have a question to the current ArchiCAD ODBC driver. When we send the query "SELECT * FROM OBJECTS WHERE SURFACE <> 0 AND VOLUME <> 0" to the inbuilt ArchiCAD SQL engine, all the objects are shown in the IE.
Unfortunately, when I do the same query with the ArchiCAD ODBC driver, I get only two entries.
Does anybody has an idea why the ODBC driver does not return the expected rows?

(I use Delphi and the ODBC driver via ADO)
2 REPLIES 2
Anonymous
Not applicable
Jürgen wrote:
We have a question to the current ArchiCAD ODBC driver. When we send the query "SELECT * FROM OBJECTS WHERE SURFACE <> 0 AND VOLUME <> 0" to the inbuilt ArchiCAD SQL engine, all the objects are shown in the IE.
Unfortunately, when I do the same query with the ArchiCAD ODBC driver, I get only two entries.
Does anybody has an idea why the ODBC driver does not return the expected rows?

(I use Delphi and the ODBC driver via ADO)
Jürgen,
Try:
SELECT * FROM OBJECTS WHERE SURFACE != 0 AND VOLUME != 0

Dan K
Anonymous
Not applicable
Thanks for your tip. Unfortunately, the statement with the != operator does not lead to the required result.
One more info:
When I select the data in the inbuilt SQL engine of ArchiCAD and look at the volumes and areas, I can see the correct values.
If I select all the records via ODBC and ADO, all the values are null.

Any hints for me?