topic Re: Questions to ArchiCAD ODBC driver 9.x in Archicad C++ API

Questions to ArchiCAD ODBC driver 9.x

Anonymous — Tue, 24 Sep 2024 08:07:01 GMT

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)

Re: Questions to ArchiCAD ODBC driver 9.x

Anonymous — Tue, 24 May 2005 12:17:59 GMT

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

Re: Questions to ArchiCAD ODBC driver 9.x

Anonymous — Tue, 24 May 2005 16:17:27 GMT

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?