cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 
Developer forum

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?

Still looking?

Browse more topics

Back to forum

See latest solutions

Accepted solutions

Start a new discussion!