5.0

• Select your ODBC Driver from the drop-down list box and click on the Setup... button to setup that
driver. The driver will walk you through the setup options. If you have difficulties setting up your
connection details, contact your database administrator.
The box underneath will show the connection string.
Note
This is editable, though should only be changed with care. Under most circumstances this can be
left alone.
Some examples are:
• Connection string: Selecting a database with a certain name (test.mdb) that is always next to the
model file (as in the resultant NWD/NWF not the original):
DBQ=%pushpath(%poppath(%currentpath),"test.mdb");DRIVER={Microsoft Access Driver (*.mdb)};
• Connection string: Selecting a database with the same name as the original model file (e.g.
AutoPlant):
DBQ=%join(%removeext(%removepath(%sourcepath)),".mdb");DRIVER={Microsoft Access Driver (*.mdb)};
• The Hold open for application lifetime check box, when checked, keeps the connection to the
dbase open whilst JetStream is open, and only closes it on exit.
• The SQL String must always start with SELECT, and is used to connect to a table within the
database. Set up the query for the table by writing the SQL String.
Some SQL String examples include:
• SQL String: Selecting all columns from table Test whilst requiring that the column called Entity
Handles matches a category/property pair called Entity Handle/Value and the column called File
Name matches the original filename of the drawing:
SELECT * FROM Test WHERE "Entity Handle" = %prop("Entity Handle","Value") AND “File Name” = $removeext(%removepath(%sourcepath));
Here the path and the extension of the file name are being stripped so a file like
c:\model\3rdFloorDucts.dwg would come out as 3rdFloorDucts.
• SQL String: Selecting two columns from table Test whilst requiring that the column called Entity
Handle matches a category/property pair called Entity Handle/Value:
SELECT Name,Part FROM Test WHERE "Entity Handle" = %prop("Entity Handle","Value");
• SQL String: Selecting all columns from table Test whilst requiring that the column called Value is
within a certain range given by two category/property pairs:
DataTools
265