2005-02-09 11:52 PM - last edited on 2022-12-13 10:35 PM by Daniel Kassai
select ID, XX.PARAMETERS.VARIABLE_NAME, XX.PARAMETERS.NAME, XX.PARAMETERS.VALUE from FLAT(OBJECTS, PARAMETERS) as XX where LIBRARY_PART_NAME=' My_object_name'This query work correct through AC9 interface - I am inserting query to Calculate\SQL\Query... dialog and press to Execute button. After this I get table of parameters in IE browser. It's ok. But I want to get table by writing VBScript and query is not working. I wrote:
Dim conn, rsObjectList set conn = WScript.CreateObject("ADODB.Connection") If not IsObject(conn) Then WScript.Echo "connection: error" WScript.Quit(-1) End If WScript.Echo "connection: ok" conn.Open "AC9_Project" Set rsObjectList = conn.Execute("select ID, XX.PARAMETERS.VARIABLE_NAME, XX.PARAMETERS.NAME, XX.PARAMETERS.VALUE from FLAT(OBJECTS, PARAMETERS) as XX where LIBRARY_PART_NAME='My_object_name'") ...If I execute script I have follow error message in result window:
connection: okIf I excecute sample query like '
<name_of_project>(error in line 'Set rsObjectList..') Microsoft OLE DB Provider for ODBC Drivers: [Graphisoft][QEODBC]Failed to execute the specified statement.
2005-02-10 06:31 PM
2005-02-10 07:01 PM
2005-02-10 09:43 PM
Juha wrote:Hi Juha,
Noticed that you have both Mac & PC. I've understood that ODBC driver
is PC only…have you connected to a PC served ArchiCAD-database with your Mac?
2005-02-11 10:18 AM
2005-02-11 04:39 PM
2005-02-11 06:14 PM
2005-02-12 03:49 AM
Denis wrote:You're welcome! I hope you get the contract.
A lot of thanks, Karl!
2005-02-13 08:28 AM
Karl wrote:we have been using ODBC to connect to the ArchiCAD data file for a while now (using filemaker 7) with great success. A few points of interest
(It is very interesting ... after nobody has talked about ODBC since it was released, we have two new people looking at it!)