What's New V9 (DriveWorks Documentation)

Overview

DriveWorks Solo 9 includes many enhancements and improvements that will increase productivity and enhance the user experience.

Project Designer Enhancements

Project Designer start-performance has been greatly improved.
Project Designer will automatically select the currently open project in the Create a New Specification dialog.
Variables and Categories are now sorted more naturally when the variable or category ends with a number.
Undo/Redo is now fully supported in both the Model and Drawing Rules.

Rule Builder & Rule Enhancements

Speedier time-to-open.
New Drill Down Feature.
Collapsible Command Bar.
Wizards added for Sum and Concatenate functions.

Formatted Strings

Text strings can be formatted to include additional elements by using the @ symbol at the beginning of the string to be formatted.

At the point where the formatting is to be inserted use the @ symbol again and enclose the formatting within brackets ().

Examples

Formatted String	Meaning
@"Thank you for submitting your order, number @( DWVariableOrderNumber)"	Returns: "Thank you for submitting your order, number 12345" The value 12345 is calculated from the variable OrderNumber.
@"The overall height will be @(HeightReturn + 2*DWVariableClearance)mm and the overall width will be @(DWVariableUnitAWidth + DWVariableUnitBWidth)mm"	Returns: "The overall height will be 2187mm and the overall width will be 1675mm" The value 2187 is calculated from the value of the Height control added to 2 * the variable Clearance. The value 1675 is calculated from the sum of the variables UnitAWidth and UnitBWidth

Formatted String

Meaning

@"Thank you for submitting your order, number @( DWVariableOrderNumber)"

Returns: "Thank you for submitting your order, number 12345"

The value 12345 is calculated from the variable OrderNumber.

@"The overall height will be @(HeightReturn + 2*DWVariableClearance)mm and the overall width will be @(DWVariableUnitAWidth + DWVariableUnitBWidth)mm"

Returns: "The overall height will be 2187mm and the overall width will be 1675mm"

The value 2187 is calculated from the value of the Height control added to 2 * the variable Clearance.

The value 1675 is calculated from the sum of the variables UnitAWidth and UnitBWidth

New Functions

VariableSumMultiply

Adds the product of the variables that match the given name within the given category.

Syntax

VariableSumMultiply( [Category Path], [Variable Filter 1], [Variable Filter 2] )

Category Path is the path to the category whose variables will be processed, nested categories can be separated with the backslash.

Variable Filter 1 is a string which will be used to match variables.

Variable Filter 2 is a string which will be used to match variables.

Examples

Rule	Meaning
VariableSumMultiply("Quote\LineItem","UnitPrice","Qty")	Will multiply all variables, in the Quote\LineItem category, ending in UnitPrice with those ending in Qty

VariableSum

Adds all variables within a category that match the given name.

Syntax

VariableSum( [Category Path], [Variable Filter] )

Category Path is the path to the category whose variables will be processed, nested categories can be separated with the backslash.

Variable Filter is a string which will be used to match variables.

Examples

Rule	Meaning
VariableSum("Quote\LineItem","* TotalPrice")	Will add all variables, in the Quote\LineItem category, ending in TotalPrice

VariableGetUniqueNumber

Gets a unique number for a variable which belongs to a sequence of variables.

Syntax

VariableGetUniqueNumber( [Variable Prefix], [Variable Suffix], [Variable Index] )

Variable Prefix is the name of the variable that appears before its number.

Variable Suffix is the name of the variable that appears after its number.

Variable Index is the number of the variable for which to calculate the unique number.

The sequence of numbers used in the variable names must run consecutively, without any numbers being skipped.

Variable Prefix and Suffix values are not case sensitive.

Variables that result in text strings are also not case sensitive.

This function will search in all categories and sub-categories for variables that match the specified prefix and suffix values.

Examples - Using Variable Prefix

Refer to Variable Names table below

Rule	Result	Why?
VariableGetUniqueNumber("Var","", 1)	1	Because "Hello" is the first unique value in the sequence of variables running from Var1 to Var 1
VariableGetUniqueNumber("Var","", 2)	2	Because "World" is the second unique value in the sequence of variables running from Var1 to Var 2
VariableGetUniqueNumber("Var","", 3)	1	Because "Hello" was already assigned the number 1 in the sequence of variables running from Var1 to Var 3
VariableGetUniqueNumber("Var","", 4)	3	Because "John" is the third unique value in the sequence of variables running from Var1 to Var 4

Example Variables

Variable Name	Value
Var1	"Hello"
Var2	"World"
Var3	"Hello"
Var4	"John"

Examples - Using Variable Prefix and Suffix

Refer to Variable Names table below

Rule	Result	Why?
VariableGetUniqueNumber("Item","Qty", 1)	1	Because 8 is the first unique value in the sequence of variables running from Var1 to Var 1
VariableGetUniqueNumber("Item","Qty", 3)	3	Because 18 is the third unique value in the sequence of variables running from Var1 to Var 3
VariableGetUniqueNumber("Item","Qty", 4)	2	Because 12 was already assigned the number 2 in the sequence of variables running from Var1 to Var 4
VariableGetUniqueNumber("Item","Qty", 5)	4	Because 27 is the fourth unique value in the sequence of variables running from Var1 to Var 5

Example Variables

Variable Name	Value
Item1Qty	8
Item2Qty	12
Item3Qty	18
Item4Qty	12
Item5Qty	27

Indirect

Evaluates the result of a rule provided as a string

Syntax

INDIRECT( [String] )

String is the rule to evaluate.

Examples

Rule	Meaning
INDIRECT("DWVariableQuoteItem" & ItemReturn)	When ItemReturn results in 2 the result will be the value of the variable DWVariableQuoteItem 2
INDIRECT("IF(DWVariableQuoteItem" & ItemReturn &"<2,""A"",""B"")")	Will evaluate the result of the variable DWVariableQuoteItem 3 (When ItemReturn results in 3) and return A if it is less than 2 otherwise will return B.

TableAverage

Gets the average of the values in a column of the given table.

Syntax

TableAverage( [Table], [ Column Index])

Table is the table that is to be filtered.

Column Index is the column number the Condition is to be applied to.

Examples

Rule	Meaning
TableAverage(DwLookup Items, 4)	Gets the average of the values in column 4 of the Items table (below), result will be 482.08

Sample Data Table

Items Table

Item	Width	Position	Cost
Single Drawer Unit	600	Rear Wall	330
Double Drawer Unit	900	Rear Wall	495
Single Cupboard Full	600	Rear Wall	280
Double Cupboard Full	900	Rear Wall	440
Single Cupboard with Drawer	600	Left Wall	300
Double Cupboard with Drawer	1200	Left Wall	600
Cupboard Left Drawer Right	1200	Left Wall	610
Cupboard Right Drawer Left	1200	Left Wall	610
Single Cupboard with Drawer	600	Right Wall	300
Double Cupboard with Drawer	1200	Right Wall	600
Cupboard Left Drawer Right	1200	Right Wall	610
Cupboard Right Drawer Left	1200	Right Wall	610

TableFilter

Eliminates non-matching values from the table that meet the given condition.

Syntax

TableFilter( Table, Column Index, Condition )

Table is the table that is to be filtered.

Column Index is the column number the Condition is to be applied to.

Condition is the search condition that when matched will filter the table.

Examples

Rule	Meaning
TableFilter(DwLookupItems,2,">900")	Filters the table to show only the values where column 2 (Width), of the Items table (below), is greater than 900. Will result in: {"Item","Width","Position","Cost";"Double Cupboard with Drawer","1200","Left Wall","600";"Cupboard Left Drawer Right","1200","Left Wall","610";"Cupboard Right Drawer Left","1200","Left Wall","610";"Double Cupboard with Drawer","1200","Right Wall","600";"Cupboard Left Drawer Right","1200","Right Wall","610";"Cupboard Right Drawer Left","1200","Right Wall","610"}

Rule

Meaning

TableFilter(DwLookupItems,2,">900")

Filters the table to show only the values where column 2 (Width), of the Items table (below), is greater than 900. Will result in:

{"Item","Width","Position","Cost";"Double Cupboard with Drawer","1200","Left Wall","600";"Cupboard Left Drawer Right","1200","Left Wall","610";"Cupboard Right Drawer Left","1200","Left Wall","610";"Double Cupboard with Drawer","1200","Right Wall","600";"Cupboard Left Drawer Right","1200","Right Wall","610";"Cupboard Right Drawer Left","1200","Right Wall","610"}

Header rows will be included in the result

Array Result Displayed as a Table

Item	Width	Position	Cost
Double Cupboard with Drawer	1200	Left Wall	600
Cupboard Left Drawer Right	1200	Left Wall	610
Cupboard Right Drawer Left	1200	Left Wall	610
Double Cupboard with Drawer	1200	Right Wall	600
Cupboard Left Drawer Right	1200	Right Wall	610
Cupboard Right Drawer Left	1200	Right Wall	610

Sample Data Table

Items Table

Item	Width	Position	Cost
Single Drawer Unit	600	Rear Wall	330
Double Drawer Unit	900	Rear Wall	495
Single Cupboard Full	600	Rear Wall	280
Double Cupboard Full	900	Rear Wall	440
Single Cupboard with Drawer	600	Left Wall	300
Double Cupboard with Drawer	1200	Left Wall	600
Cupboard Left Drawer Right	1200	Left Wall	610
Cupboard Right Drawer Left	1200	Left Wall	610
Single Cupboard with Drawer	600	Right Wall	300
Double Cupboard with Drawer	1200	Right Wall	600
Cupboard Left Drawer Right	1200	Right Wall	610
Cupboard Right Drawer Left	1200	Right Wall	610

TableDistinct

Eliminates non-distinct values in the table.

Syntax

TableDistinct( [Table], [ Column Index ], )

Table is the table that is to be filtered.

Column Index is the column number the Condition is to be applied to.

Examples

Rule	Meaning
TableDistinct(DwLookup Items, 2)	Filters the table to show only the distinct values from column 2 (Width), of the Items table (below). Will result in: {"Item","Width","Position","Cost";"Single Drawer Unit","600","Rear Wall","330";"Double Drawer Unit","900","Rear Wall","495";"Double Cupboard with Drawer","1200","Left Wall","600"}

Rule

Meaning

TableDistinct(DwLookup Items, 2)

Filters the table to show only the distinct values from column 2 (Width), of the Items table (below). Will result in:

{"Item","Width","Position","Cost";"Single Drawer Unit","600","Rear Wall","330";"Double Drawer Unit","900","Rear Wall","495";"Double Cupboard with Drawer","1200","Left Wall","600"}

Sample Data Table

Items Table

Item	Width	Position	Cost
Single Drawer Unit	600	Rear Wall	330
Double Drawer Unit	900	Rear Wall	495
Single Cupboard Full	600	Rear Wall	280
Double Cupboard Full	900	Rear Wall	440
Single Cupboard with Drawer	600	Left Wall	300
Double Cupboard with Drawer	1200	Left Wall	600
Cupboard Left Drawer Right	1200	Left Wall	610
Cupboard Right Drawer Left	1200	Left Wall	610
Single Cupboard with Drawer	600	Right Wall	300
Double Cupboard with Drawer	1200	Right Wall	600
Cupboard Left Drawer Right	1200	Right Wall	610
Cupboard Right Drawer Left	1200	Right Wall	610

TableMax

Gets the row containing the maximum of the values in a column of the given table.

Syntax

TableMax( [Table], [ Column Index ], )

Table is the table that is to be filtered.

Column Index is the column number the Condition is to be applied to.

Examples

Rule	Meaning
TableMax(DwLookup Items,4)	Gets the first row to be found with the largest value in column 4 (Cost), of the Items table (below). Will result in: {"Cupboard Left Drawer Right","1200","Left Wall","610"}

Rule

Meaning

TableMax(DwLookup Items,4)

Gets the first row to be found with the largest value in column 4 (Cost), of the Items table (below). Will result in:

{"Cupboard Left Drawer Right","1200","Left Wall","610"}

Sample Data Table

Items Table

Item	Width	Position	Cost
Single Drawer Unit	600	Rear Wall	330
Double Drawer Unit	900	Rear Wall	495
Single Cupboard Full	600	Rear Wall	280
Double Cupboard Full	900	Rear Wall	440
Single Cupboard with Drawer	600	Left Wall	300
Double Cupboard with Drawer	1200	Left Wall	600
Cupboard Left Drawer Right	1200	Left Wall	610
Cupboard Right Drawer Left	1200	Left Wall	610
Single Cupboard with Drawer	600	Right Wall	300
Double Cupboard with Drawer	1200	Right Wall	600
Cupboard Left Drawer Right	1200	Right Wall	610
Cupboard Right Drawer Left	1200	Right Wall	610

TableMaxValue

Gets the maximum value from a column in a table.

Syntax

TableMaxValue( [Table], [ Column Index ], )

Table is the table that is to be filtered.

Column Index is the column number the Condition is to be applied to.

Examples

Rule	Meaning
TableMaxValue(DwLookup Items,4)	Gets the maximum value in column 4 (Cost), of the Items table (below). Will result in: 610

Rule

Meaning

TableMaxValue(DwLookup Items,4)

Gets the maximum value in column 4 (Cost), of the Items table (below). Will result in:

610

Sample Data Table

Items Table

Item	Width	Position	Cost
Single Drawer Unit	600	Rear Wall	330
Double Drawer Unit	900	Rear Wall	495
Single Cupboard Full	600	Rear Wall	280
Double Cupboard Full	900	Rear Wall	440
Single Cupboard with Drawer	600	Left Wall	300
Double Cupboard with Drawer	1200	Left Wall	600
Cupboard Left Drawer Right	1200	Left Wall	610
Cupboard Right Drawer Left	1200	Left Wall	610
Single Cupboard with Drawer	600	Right Wall	300
Double Cupboard with Drawer	1200	Right Wall	600
Cupboard Left Drawer Right	1200	Right Wall	610
Cupboard Right Drawer Left	1200	Right Wall	610

TableMin

Gets the row containing the minimum of the values in a column of the given table.

Syntax

TableMin( [Table], [ Column Index ], )

Table is the table that is to be filtered.

Column Index is the column number the Condition is to be applied to.

Examples

Rule	Meaning
TableMin(DwLookup Items,4)	Gets the first row to be found with the smallest value in column 4 (Cost), of the Items table (below). Will result in: {"Single Cupboard Full","600","Rear Wall","280"}

Rule

Meaning

TableMin(DwLookup Items,4)

Gets the first row to be found with the smallest value in column 4 (Cost), of the Items table (below). Will result in:

{"Single Cupboard Full","600","Rear Wall","280"}

Sample Data Table

Items Table

Item	Width	Position	Cost
Single Drawer Unit	600	Rear Wall	330
Double Drawer Unit	900	Rear Wall	495
Single Cupboard Full	600	Rear Wall	280
Double Cupboard Full	900	Rear Wall	440
Single Cupboard with Drawer	600	Left Wall	300
Double Cupboard with Drawer	1200	Left Wall	600
Cupboard Left Drawer Right	1200	Left Wall	610
Cupboard Right Drawer Left	1200	Left Wall	610
Single Cupboard with Drawer	600	Right Wall	300
Double Cupboard with Drawer	1200	Right Wall	600
Cupboard Left Drawer Right	1200	Right Wall	610
Cupboard Right Drawer Left	1200	Right Wall	610

TableMinValue

Gets the minimum value from a column in a table.

Syntax

TableMinValue( [Table], [ Column Index ], )

Table is the table that is to be filtered.

Column Index is the column number the Condition is to be applied to.

Examples

Rule	Meaning
TableMinValue(DwLookup Items,4)	Gets the minimum value in column 4 (Cost), of the Items table (below). Will result in: 280

Rule

Meaning

TableMinValue(DwLookup Items,4)

Gets the minimum value in column 4 (Cost), of the Items table (below). Will result in:

280

Sample Data Table

Items Table

Item	Width	Position	Cost
Single Drawer Unit	600	Rear Wall	330
Double Drawer Unit	900	Rear Wall	495
Single Cupboard Full	600	Rear Wall	280
Double Cupboard Full	900	Rear Wall	440
Single Cupboard with Drawer	600	Left Wall	300
Double Cupboard with Drawer	1200	Left Wall	600
Cupboard Left Drawer Right	1200	Left Wall	610
Cupboard Right Drawer Left	1200	Left Wall	610
Single Cupboard with Drawer	600	Right Wall	300
Double Cupboard with Drawer	1200	Right Wall	600
Cupboard Left Drawer Right	1200	Right Wall	610
Cupboard Right Drawer Left	1200	Right Wall	610

TableSum

Gets the sum of the values in a column of the given table.

Syntax

TableSum( [Table], [ Column Index])

Table is the table that is to be filtered.

Column Index is the column number the Condition is to be applied to.

Examples

Rule	Meaning
TableSum(DwLookup Items, 4)	Gets the average of the values in column 4 of the Items table (below), result will be 5785

Sample Data Table

Items Table

Item	Width	Position	Cost
Single Drawer Unit	600	Rear Wall	330
Double Drawer Unit	900	Rear Wall	495
Single Cupboard Full	600	Rear Wall	280
Double Cupboard Full	900	Rear Wall	440
Single Cupboard with Drawer	600	Left Wall	300
Double Cupboard with Drawer	1200	Left Wall	600
Cupboard Left Drawer Right	1200	Left Wall	610
Cupboard Right Drawer Left	1200	Left Wall	610
Single Cupboard with Drawer	600	Right Wall	300
Double Cupboard with Drawer	1200	Right Wall	600
Cupboard Left Drawer Right	1200	Right Wall	610
Cupboard Right Drawer Left	1200	Right Wall	610

TableTranspose

Transposes (interchanges the columns and rows of) the given table.

Syntax

TableTranspose( [Table] )

Table is the table that is to be filtered.

Examples

Rule	Meaning
TableTranspose(DwLookup Items)	Inverts the example Items table (shown below) so the data in column 1 becomes the data in row 1, and the data in row 1 become data in column 1, resulting in: {"Item","Single Drawer Unit","Double Drawer Unit","Single Cupboard Full","Double Cupboard Full","Single Cupboard with Drawer","Double Cupboard with Drawer","Cupboard Left Drawer Right","Cupboard Right Drawer Left","Single Cupboard with Drawer","Double Cupboard with Drawer","Cupboard Left Drawer Right","Cupboard Right Drawer Left";"Width","600","900","600","900","600","1200","1200","1200","600","1200","1200","1200";"Position","Rear Wall","Rear Wall","Rear Wall","Rear Wall","Left Wall","Left Wall","Left Wall","Left Wall","Right Wall","Right Wall","Right Wall","Right Wall";"Cost","330","495","280","440","300","600","610","610","300","600","610","610"}

Rule

Meaning

TableTranspose(DwLookup Items)

Inverts the example Items table (shown below) so the data in column 1 becomes the data in row 1, and the data in row 1 become data in column 1, resulting in:

{"Item","Single Drawer Unit","Double Drawer Unit","Single Cupboard Full","Double Cupboard Full","Single Cupboard with Drawer","Double Cupboard with Drawer","Cupboard Left Drawer Right","Cupboard Right Drawer Left","Single Cupboard with Drawer","Double Cupboard with Drawer","Cupboard Left Drawer Right","Cupboard Right Drawer Left";"Width","600","900","600","900","600","1200","1200","1200","600","1200","1200","1200";"Position","Rear Wall","Rear Wall","Rear Wall","Rear Wall","Left Wall","Left Wall","Left Wall","Left Wall","Right Wall","Right Wall","Right Wall","Right Wall";"Cost","330","495","280","440","300","600","610","610","300","600","610","610"}

Sample Data Table

Items Table

Item	Width	Position	Cost
Single Drawer Unit	600	Rear Wall	330
Double Drawer Unit	900	Rear Wall	495
Single Cupboard Full	600	Rear Wall	280
Double Cupboard Full	900	Rear Wall	440
Single Cupboard with Drawer	600	Left Wall	300
Double Cupboard with Drawer	1200	Left Wall	600
Cupboard Left Drawer Right	1200	Left Wall	610
Cupboard Right Drawer Left	1200	Left Wall	610
Single Cupboard with Drawer	600	Right Wall	300
Double Cupboard with Drawer	1200	Right Wall	600
Cupboard Left Drawer Right	1200	Right Wall	610
Cupboard Right Drawer Left	1200	Right Wall	610

DWHLookup

Returns a value from a table corresponding to a match found in the specified row.

Syntax

DWHLookup( [Value], [ Table Name], [ Lookup Row], [ Result Row Index], [ MatchType] )

Value is the value to be found.

Table Name is the table within which the value is to be found.

Lookup Row is the number of the row containing the data to be searched for.

Result Row Index is the number of the row containing the data to be returned.

MatchType defines whether the match has to be exact (False) or the nearest found (True).

Examples

Rule	Meaning
DWHLookup(CarColourComboBoxReturn, Vehicles, 3, 2, FALSE)	The function looks in the Vehicles table for a match, in the third row of the table, to the value returned from the CarColourComboBox. If a match is found, the function then looks up to the second row and returns the value in the same column as the match found. The user has also specified that the match needs to be exact (denoted by the FALSE term). In this case, the Car Colour selected in the combo box is "Blue", so the function returns "Golf".

Rule

Meaning

DWHLookup(CarColourComboBoxReturn, Vehicles, 3, 2, FALSE)

The function looks in the Vehicles table for a match, in the third row of the table, to the value returned from the CarColourComboBox. If a match is found, the function then looks up to the second row and returns the value in the same column as the match found. The user has also specified that the match needs to be exact (denoted by the FALSE term). In this case, the Car Colour selected in the combo box is "Blue", so the function returns "Golf".

Example Outcomes

Lookup	In	Lookup Row	Result Row Index	MatchType	Outcome
"Blue"	Vehicles	3	2	False (Exact)	"Golf"
"White"	Vehicles	3	1	False (Exact)	"Renault"
26	People	3	2	True (Nearest)	"Dave Sharp"
42	People	3	4	False (Exact)	"Female"

Example Data

Vehicles Table

Make	Volkswagen	Ford	Renault	Mazda
Model	Golf	Escort	Kangoo	2
Colour	Blue	Red	White	Black

People Table

Member ID	42	44	96	107	251
Name	Dave Sharp	Joe Bloggs	Sandra Shield	Thomas Knight	Isabelle Jones
Age	25	37	42	21	56
Gender	Male	Male	Female	Male	Female

HLookup

Returns a value from a table corresponding to a match found in the first row.

Syntax

HLOOKUP( [ Value], [ TableName], [ RowIndex], [ MatchType] )

Value is the value to be found.

TableName is the table within which the Lookup value is to be found.

RowIndex is the number of the row containing the data to be returned.

MatchType defines whether the match has to be exact (False) or the nearest found (True).

Examples

Rule	Meaning
HLOOKUP(CarMakeComboBoxReturn, Vehicles, 2, FALSE)	The function looks in the Vehicles table for a match, in the first row of the table, to the value returned from the CarMakeComboBox. If a match is found, the function then looks down to the second column and returns the value in the same row as the match found. The user has also specified that the match needs to be exact (denoted by the FALSE term). In this case, the Car Make selected in the combo box is "Volkswagen", so the function returns "Golf".

Rule

Meaning

HLOOKUP(CarMakeComboBoxReturn, Vehicles, 2, FALSE)

The function looks in the Vehicles table for a match, in the first row of the table, to the value returned from the CarMakeComboBox. If a match is found, the function then looks down to the second column and returns the value in the same row as the match found. The user has also specified that the match needs to be exact (denoted by the FALSE term). In this case, the Car Make selected in the combo box is "Volkswagen", so the function returns "Golf".

Example Outcomes

Value	TableName	RowIndex	MatchType	Outcome
"Volkswagen"	Vehicles	2	False (Exact)	"Golf"
"Mazda"	Vehicles	3	False (Exact)	"Black"
43	People	2	True (Nearest)	"Dave Sharp"
251	People	3	False (Exact)	56

Example Data

Vehicles Table

Make	Volkswagen	Ford	Renault	Mazda
Model	Golf	Escort	Kangoo	2
Colour	Blue	Red	White	Black

People Table

Member ID	42	44	96	107	251
Name	Dave Sharp	Joe Bloggs	Sandra Shield	Thomas Knight	Isabelle Jones
Age	25	37	42	21	56
Gender	Male	Male	Female	Male	Female

FsDirectoryExists

Returns TRUE if the specified directory location exists. FALSE is returned if it does not.

An error string is returned if there are any problems checking for existence.

Syntax

FsDirectoryExists( [Directory Location] )

Where:

Directory Location is the directory location to check. If a full path is not specified the function will check for the location relative to where the project is stored.

Examples

Rule	Meaning
FsDirectoryExists("E:\DriveWorks")	Will check to see if the location E:\DriveWorks exists and return True if so.
FsDirectoryExists("\\DRIVEWORKS-DATA\Specifications\" & OrderNumberReturn)	Will check to see if the location \\DRIVEWORKS-DATA\Specifications, combined with the result of the control OrderNumberReturn, exists and return True if so.

FsFileExists

Returns TRUE if the specified file location exists. FALSE is returned if it does not. An error string is returned if there are any problems checking for existence.

Syntax

FsFileExists([File Location],[Wait Time])

Where:

File Location is the file location to check. If a full path is not specified the function will check for the location relative to where the Project is stored.

Wait Time is the minimum amount of time to wait for the check to complete in seconds. After the specified time if the file was not found the function will return the message "#IO! Timed out" (This property is optional).

This function could affect performance (when the file being checked is located on an unreachable network for instance). Therefore the Rules Builder or Analyze Rule function in Test Mode will not display the result of the function, a blank will be displayed instead.

Examples

Rule	Result	Meaning
FsFileExists("C:\DriveWorks\DataSheets\Product.pdf")	TRUE	Will check to see if the file exists in the given location.
FsFileExists("C:\DriveWorks\Specifications\"&OrderNumberReturn&"\Quote.doc")	TRUE	Will check to see if the file exists. This example shows how you would find a file for a specific Specification.

MyName

Gets the name assigned to the owner of the rule.

Syntax

MyName()

Examples

Rule	Meaning
Data and Form Controls - see How To: reference Control Properties.
MyName()	When applied to a variable named TotalCost will result in DWVariableTotalCost
MyName()	When applied to a dynamic form control property the result will be the name of the control followed by the property name, for example: ControlNameEnabled ControlNameVisible ControlNameError ControlNameMin ControlNameMax ControlNameListData ControlName.Width
Model Rules - see Model Rules General.
MyName()	When applied to a default parameter the result will be: ParentName\ChildName\Name (for File Name) ParentName\ChildName\Path (for Relative Path) ParentName\ChildName\Configuration (for Configuration) For example: My Assembly\My Part\Path
MyName()	When applied to a captured dimension the result will be: ParentName\ChildName\CapturedDimensionName For example: My Assembly\My Part\Length
MyName()	When applied to a captured feature the result will be: ParentName\ChildName\CapturedFeatureName\SuppressionState For example: My Assembly\My Part\Boss\SuppressionState
MyName()	When applied to a captured custom property the result will be: ParentName\ChildName\CustomPropertyname For example: My Assembly\My Part\Date
MyName()	When applied to a captured instance the result will be: ParentName\ChildName\PartName-InstanceNumber For example: My Assembly\My Part\MyPart-2
Drawing Rules - see Drawing Rules General.
MyName()	When applied to a default parameter the result will be: ParentName\ChildName\DrawingName\Name (for File Name) ParentName\ChildName\DrawingName\Path (for Relative Path) For example: My Assembly\My Part\My Drawing\Path
DriveWorks 3D Document - see DriveWorks 3D File.
MyName()	When applied to a DriveWorks 3D Document parameter the result will be: File Name\Parent Component Name\Child Component Name\ParameterName For example: My Drive3D File\ParentComponent\ChildComponent\Appearance My Drive3D File\ParentComponent\ChildComponent\ReplacementFilePath My Drive3D File\ParentComponent\ChildComponent\XPosition My Drive3D File\ParentComponent\ChildComponent\ZRotation

GetNumericSuffix

Gets the numeric suffix from a piece of text.

Syntax

GetNumericSuffix( [Text] )

Where:

Text is the text from which to get the numeric suffix.

Examples

Rule	Meaning
GetNumericSuffix(MyName())	When applied to a variable named LineItem1 will return the number 1 as being the numeric suffix

IsErrorString

Returns TRUE if the specified value is an error string. Otherwise FALSE will be returned.

Syntax

ISERRORSTRING( [Value] )

Value is the value to check

Examples

Rule	Meaning
IsErrorString(DWVariableCustomerNames)	Will check the variable CustomerNames for an error string and report True if the value is reporting an error.
IsErrorString("#DBCONNECT! (""Could not connect to server"")")	Returns True as #DBCONNECT! ("Could not connect to server") is a valid error string.

HashMD5

Computes the MD5 hash of the specified value and returns it in hexadecimal.

Syntax

HashMD5( [Value] )

Where:

Value is the value to compute the MD5 hash from.

Examples

Rule	Meaning
HashMD5("My text to hash")	Returns a hexadecimal value from the MD5 hash of the text My text to hash.
HashMD5(123456)	Returns a hexadecimal value from the MD5 hash of the number 123456 after first converting it to text.
HashMD5(DWCurrentUserPassword)	Returns a hexadecimal value from the MD5 hash of the special variable DWCurrentUserPassword.

HashSHA1

Computes the SHA1 hash of the specified value and returns it in hexadecimal.

Syntax

HashSHA1( [Value] )

Where:

Value is the value to compute the SHA1 hash from.

Examples

Rule	Meaning
HashSHA1("My text to hash")	Returns a hexadecimal value from the SHA1 hash of the text My text to hash.
HashSHA1(123456)	Returns a hexadecimal value from the SHA1 hash of the number 123456 after first converting it to text.
HashSHA1(DWCurrentUserPassword)	Returns a hexadecimal value from the SHA1 hash of the special variable DWCurrentUserPassword.

User Form Enhancements

Labels now support center and right horizontal alignment of text.
Properties which represent file names, forms, documents, and more are now contextually aware and provide an appropriate user interface for selecting the desired value.

Hide Characters Property for Text Boxes

Hide Characters

The Hide Characters property will mask the data being entered into the control.

Property Type: Static

Default Value: False

About

By default the Hide Characters property is set to False.

The Hide Characters property requires a Boolean value (True or False).

Examples

Hide Characters Property Value (static)	Result	Notes
True	Will mask any characters entered into the text box	The value can be selected by clicking the drop down that accompanies the property.
False	Will display the characters exactly as entered into the text box	The value can be selected by clicking the drop down that accompanies the property.

Hide Characters Property Value (dynamic)	Result	Notes
IF(DWVariablePasswordRequired = "Yes", TRUE, FALSE)	Will mask any characters entered into the text box when the value of the variable PasswordRequired is "Yes".	The value can be set by making the property dynamic (see above), launching the rule builder and applying the function.

Value set in Form Designer. For DriveWorks projects static properties can be made Dynamic by double clicking the gray radio button.

Word Wrap Property for Text Boxes

Word Wrap

The Word Wrap property will wrap the data being entered to fit within the width of the control.

Property Type: Static

Default Value: False

About

By default the Word Wrap property is set to False.

The Word Wrap property requires a boolean value (True or False).

The behavior of the Word Wrap property is affected by the value of the Multiline property.

See Examples below.

Examples

Word Wrap Property Value (static)	Multiline Property Value (static)	Result
False	False	Data entered extends beyond the width of the control.
False	True	Data entered extends beyond the width of the control. Horizontal scroll bars allow extent of the data to be reached.
True	False
True	True

Word Wrap Property Value (dynamic)	Result	Result
IF(DWVariableNumberOfChars > 50, TRUE, FALSE)	Will mask any characters entered into the text box when the value of the variable SelectionRequired is "Yes".

Value set in Form Designer. For DriveWorks projects static properties can be made Dynamic by double clicking the gray radio button.

Search Rules and Find All References

The Search Rules (available from the command bar of Project Designer) and the Find All References (available by right clicking on a reference in the Rule Builder) functions now allow rules to be modified.

Select the rule from the Search Rules dialog and click Build Rule to launch the Rule Builder.

If the rule contains a reference (for instance a variable or form control), right clicking on the reference and selecting Find All References, will display all instances where that reference is used. Each of these instances can also be modified directly in the Search Rules dialog.

The Search Rules dialog, that displays the rules, now displays the current value of all rules and references found.

SOLIDWORKS Enhancements

Break Lines can now be easily deleted in DriveWorks.

Breakline Rules

Breakline rules are used to control the position of the breaklines relative to the left and right of the view.

The Distance 1 reference is to the first breakline from the left of the view edge.

The Distance 2 reference is to the second breakline from the right of the view edge.

If the breakline is not required forcing the rule to result in "Delete" will remove the breakline from the drawing.

Distance 1 Rule	Distance 2 Rule	Meaning
15	35	Sets the first breakline 15 document units from the left of the view, and the second breakline 35 document units from the right of the view.
DWVariableBreakLeft	DWVariableBreakRight	Sets the first breakline to the value calculated by DWVariableBreakLeft from the left of the view, and the second breakline to the value calculated by DWVariableBreakRight from the right of the view.
IF(LengthReturn<2000,15,45)	IF(LengthReturn<2000,35,65)	Sets the first breakline 15 document units from the left, when the Length is less than 2000 and 45 document units from the left when the Length is greater than 2000. Sets the second breakline 35 document units from the right, when the Length is less than 2000 and 65 document units from the right when the Length is greater than 2000.
IF(LengthReturn<2000, "Delete",45)	IF(LengthReturn<2000, "Delete",65)	Will delete the first breakline, when the Length is less than 2000 or set it to 45 document units from the left when the Length is greater than 2000. Will delete the second breakline, when the Length is less than 2000 and set it to 65 document units from the right when the Length is greater than 2000. Note When either of the breakline values result in "Delete" both will be deleted.

For more accurate control of breakline positions we recommend creating planes in the model from which the breaklines can be dimensioned from. Capture the plane distance and control the breakline position from the plane. Set the distance from the plane to the breakline to a minimum nominal value.

The Generation Dialog in the SOLIDWORKS Task Pane can now be refreshed without closing and reopening the dialog.

Welcome
What's New
- DriveWorks 22
- Older Versions
  - DriveWorks 21
  - DriveWorks 20
  - DriveWorks 19
  - DriveWorks 18
  - DriveWorks 17
  - DriveWorks 16
    - SP0
      - DriveWorks V16 SP0 Information
      - Enhancements
    - SP1
      - Bug Fixes
    - SP2
      - Enhancements
      - Bug Fixes
  - DriveWorks 15
    - SP0
      - Enhancements
    - SP1
      - Bug Fixes
    - SP2
      - DriveWorks V15 SP2 Information
      - Bug Fixes
  - DriveWorks 14
    - SP0
      - Enhancements
      - Bug Fixes
    - SP1
      - Bug Fixes
    - SP2
      - Bug Fixes
  - DriveWorks 12
    - What's New DriveWorks 12
    - Form Design
      - Form Design - General Enhancements
    - Rule Builder
      - Functions
      - Functions - Table
    - Model Rules
      - Copy Model Rules
    - DriveWorks Add-in for SOLIDWORKS
      - Advanced Feature Parameters
    - SP1
      - Bug Fixes
    - SP2
  - DriveWorks 11
    - Welcome to DriveWorks Solo 11 What's New
    - Capturing
      - Dynamic File Formats
    - Project Designer
      - Task Status
      - Renaming Controls and Variables
      - Rule Builder
        Functions
        Variable Categories and Rules Insight Escape
      - Form Design
        Control Guides
        Group Controls
        Form Controls
        Keyboard Control Positioning
        Text Box
        Option Group
        Decimal Places Property
      - Documents
        Document Edit Notification
      - Model Rules
    - Installation
      - Installation
    - Licensing
      - Licensing
    - SP1
      - Bug Fixes
    - SP1.1
      - Bug Fixes
    - SP2
      - Bug Fixes
    - SP3
      - Bug Fixes
  - V10
    - What's New DriveWorks 10
    - What's New Form Designer
    - What's New Drawing Rules
    - What's New Create Variables
    - SP1
      - Bug Fixes
    - SP2
      - Bug Fixes
    - SP2.1
      - Bug Fixes
    - SP3
      - Bug Fixes
  - V9
    - SP0
      - What's New V9
      - SP1
        Enhancements
        Bug Fixes
      - SP2
        Bug Fixes
      - SP3
        Compatibility
        Bug Fixes
      - SP4
        Bug Fixes
  - V8
    - SP0
    - SP1
    - SP2
    - SP3
      - Enhancements
      - Bug Fixes
  - V7
Before You Begin
- Prerequisites
- Getting Further Help
Using DriveWorks Solo
- DriveWorks Solo Inside SOLIDWORKS
  - Enabling the DriveWorks Solo Add-ins in SOLIDWORKS
  - Project Wizard
  - Capturing Models
  - Run
  - Run (Layout Mode)
- Project Designer
  - Project Designer
  - Stage 1: User Interface
    - Form Navigation
    - Form Design
  - Stage 2: Data and Rules
    - Define Variables
    - Define Tables
  - Stage 3: Output Rules
    - Documents
    - Model Rules
      - Model Rules
- Writing Rules
Knowledge Base
Glossary

DriveWorks Solo 22 What's New V9

Overview

Project Designer Enhancements

Rule Builder & Rule Enhancements

Formatted Strings

Examples

VariableSumMultiply

Syntax

Examples

VariableSum

Syntax

Examples

VariableGetUniqueNumber

Syntax

Examples - Using Variable Prefix

Example Variables

Examples - Using Variable Prefix and Suffix

Example Variables

Indirect

Syntax

Examples

TableAverage

Syntax

Examples

Sample Data Table

Items Table

TableFilter

Syntax

Examples

Array Result Displayed as a Table

Sample Data Table

Items Table

TableDistinct

Syntax

Examples

Sample Data Table

Items Table

TableMax

Syntax

Examples

Sample Data Table

Items Table

TableMaxValue

Syntax

Examples

Sample Data Table

Items Table

TableMin

Syntax

Examples

Sample Data Table

Items Table

TableMinValue

Syntax

Examples

Sample Data Table

Items Table

TableSum

Syntax

Examples

Sample Data Table

Items Table

TableTranspose

Syntax

Examples

Sample Data Table

Items Table

DWHLookup

Syntax

Examples

Example Outcomes

Example Data

Vehicles Table

People Table

HLookup

Syntax

Examples

Example Outcomes

Example Data

Vehicles Table

DriveWorks Solo 22
What's New V9