IRubricator.TreatEmptyStringAsNull

Syntax

TreatEmptyStringAsNull: Boolean;

Description

The TreatEmptyStringAsNull property determines whether to store empty strings as Null.

Comments

The property is used only in non-version time series databases.

Available values:

True. Empty strings are stored as Null. This increases performance and reduces volume of time series database. The option is applied on executing the following operations:

Data import.
Copying time series database.
Data transformation.
Saving data from express report, regular report and workbook.
Saving data via matrices.

Features:

If the point's text attribute already contains empty value, the value is replaced with Null. The existing points are not deleted even if values of all observation attributes are Null.
A record in the observation table is not created if values of text attributes contain empty strings or Null, and values of other attributes and the VL attribute (value) are Null or nan.
Garbage data collection method deletes the series that contain all empty strings or all Null records.

False. Default value. Empty strings are stored in the initial form.

Example

Executing the example requires that the repository contains a time series database with the TSDB identifier.

Add links to the Cubes and Metabase system assemblies.

Sub UserProc;
Var
    mb: IMetabase;
    Rub: IRubricator;
Begin
    mb := MetabaseClass.Active;
    Rub := mb.ItemById("TSDB").Edit As IRubricator;
    Rub.TreatEmptyStringAsNull := True;
    (Rub As IMetabaseObject).Save;
End Sub UserProc;

After executing the example time series database parameters are changed: empty strings are stored as Null.