Questions to ArchiCAD ODBC driver 9.x

[Anonymous]

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)

[Anonymous]

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]

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?