2009

Full Tag List ”.
For example, if you want to select a database with a certain name (say, test.mdb) that is
always next to the model file (as in the resultant NWD/NWF not the original), type in:
DBQ=%pushpath(%poppath(%currentpath),"test.mdb");
DRIVER={Microsoft Access Driver (*.mdb)};
If you want to select a database with the same name as the original model file (say,
AutoPlant), type in:
DBQ=%join(%removeext(%removepath(%sourcepath)),".mdb");
DRIVER={Microsoft Access Driver (*.mdb)};
4. Select the Hold Open for Application Lifetime check box, if you want to keep the database link
open until you exit NavisWorks.
5. Specify which table in the database to query:
In the SQL String field, click after SELECT, and enter the selection statement, for
example: SELECT * FROM tblBoilerData WHERE "NWUniqueID" =
%prop("Entity Handle", "Value");
This statement instructs NavisWorks to select all columns from the tblBoilerData table,
whilst requiring that the column called NWUniqueID matches a category/property pair
called Entity Handle/Value. For the list of tags you can use in the SQL statement, see “
Full Tag List ”.
6. Select which columns you want to display as link categories on the Properties control box:
Double-click the Fields Name field, type the exact name of the database column, for
example: "PartName", and press Enter.
The Display Name is automatically completed for you, but you can click it, and enter a
different name, if you want. The text entered here is the category name shown on the link
tab of the Properties control bar.
Repeat the above process to list all required categories in the Fields area of the dialog
box.
DataTools
309