Change Numeric Database Logging Format From String to Double in TestStand

In the default TestStand database schemas, PROP_RESULT.DATA stores numeric values as strings with high precision, independent of NumericFormat. This can lead to the values being logged with extra precision, which is different than the values saved in other reports such as ATML reports.

This article describes how to edit the data types inside both the database schema (from String to Double Precision) and the database (from LongText to Double).

Step 1. Edit TestStand Database Schema column

The required data is logged at the PROP_RESULT >> DATA column. Default data type is String. You can change the type to Double Precision.

To do this, you will need to create a new Database schema as you cannot edit the default schemas. You can copy the Generic Recordset schema (or another one of your choice) and make your modifications.

Step 2. Edit Database column

Since the Data column has the type LongText, you can change its data type to match with the type you edited for the schema.

1. Open the Database using the Database Viewer via Results >> Results Processing >> Database options >> View Data.
2. Under PROP_RESULT, right-click the DATA column >> Drop Column to delete it. (NOTE: this will delete the column's data from the database - preparing a backup is recommended)
3. Right-click PROP_RESULT >> Add Column.
4. Create the DATA Column (same name as before), set the Data Type to Double and enable the Is Nullable checkbox.

Next Steps

Instead of editing the DATA column and its datatype, you can instead create a new column (in both the schema and database).