2009

Table Of Contents
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.
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");
Selecting all columns from table Test whilst requiring that the column called Value is within a certain
range given by two category/property pairs:
SELECT * FROM Test WHERE Value BETWEEN %prop("Pressure","Minimum") AND
%prop("Pressure","Maximum");
DataTools
316