244 Chapter 5
Storing and Retrieving Test Results
Customizing a Simple Test Database
Note To secure the operator interface and program from changes, select File ⇒
Create RunTime Version...
. Enter a name for the program and VEE
will automatically add a
*.vxe extension to separate it from unsecured
versions.
Performing a Sort Operation on a Record Field
This exercise uses the dataset2.vee program from a previous exercise.
The
dataset2.vee program sets a condition in the From DataSet object
such as
Rec.B>=0.5, and VEE extracts all the records that meet the
requirement. The array of resulting records is displayed in the
Record
Constant
object.
In this exercise,
dataset2.vee is modified to sort the resulting records to
determine which tests are failing by the greatest margin. The tests are sorted
by the second field in descending order.
1. Open the
dataset2.vee program.
2. Select
Device ⇒ Formula and connect the From Data Set data
output pin
Rec to the Formula object data input pin. Double-click the
Formula expression field to highlight the default formula, then enter
sort(a, 1, “B”).
The
Sort object is located in the Function & Object Browser,
Array Category functions. You can read detailed information on its
capabilities in the object menu
Help entry. The sort () function is
called from the
Formula object.
The first parameter sorts the data on the
Formula object A pin, which is
in an array of records. The second parameter indicates the direction of the
sort: any non-zero number indicates an ascending direction, a zero
indicates descending. The default direction is ascending. The third
parameter, in the case of a
Record data type, indicates the name of the
field to sort. Therefore, this performs an ascending sort on the
B field in
the array of records.
3. Select
Display ⇒ AlphaNumeric and connect it to the data output
pin of the
Formula object.