23 - 05 - 2019

DataSet Controls

Block DataSetImage:

License: Hobby, Industrial

The block allows visualization of more than one analog or digital signals together. The InDataSet input must be connected to the output of a block containing data, such as DataSetStorage, DBFStorage, SQLSelect.

 

Parameters:

 

  • DataSet - with this parameter we set which columns from incoming dataset from InDataSet input will be displayed. It is important to add a column, which exists in the incoming dataset from InDataSet input, its name to be written in the same way and to be of the same type. For example, if the incoming InDataSet is connected with an output of a block DBFStorage, the DBF has a column with name X of the analogue type, then in the DataSet parameter of the DataSetImage block we must also add a column named X of the same signal type.

Many analog and digital signals can be added, but only one type of DateTime. A DateTime signal is used to resize the X axis graph.

 

For analogue signal we can set color, min/max drawing values, size of the marker. If the input signal is incremental, we can check Incremental, first dot is zero. Good example for incremental signal is Rain - every new value of the signal is with added new rain for the period.

For digital signal we can set display levels of the ON/OFF values.

  • PeriodType - can be one of WholePeriodInDataSet, LastSeconds, LastMinutes, LastHours, LastDays. This parameter works together with parameter Last. For example, if PeriodType is LastMinutes and parameter Last is 10, the last 10 minutes from the input dataset InDataSet will be shown. If inputs FromPeriod, ToPeriod are connected, parameters PeriodType and Last are ignored.
  • Last - works together with parameter PeriodType;
  • Connect to Image control - the block has to be connected with control, which can be added from icon Controls - Image control;

 

Block's inputs:

  • InDataSet - the input DataSet, which data will be shown;
  • DoDraw - when the input becomes to high level, the control connected with this block will draw the data contained in the input InDataSet;
  • FromPeriod, ToPeriod - when this inputs are connected, parameters PeriodType and Last are ignored. The inputs the define the drawing period.

 

Block's outputs:

  • OnReady - becomes to high level after every redraw of the connected control;

 Good example of DataSetImage is a DBF.nsm diagram, which is in the Demo files.

 

Block DataSetTable:

License: Industrial

With this block, we can visualize the contents of Dataset and move on it. The InDataSet input must be connected to the output of a block containing data, such as DataSetStorage, DBFStorage, SQLSelect. Every added column at the block will appear as column at the connected table and a new block output will be added with the same name and data type as the column. When the diagram is started and user move the selected row at the Table control, the values of the block's outputs will be changed with the values of the selected row. The numer of rows in the Table controls are the same as the numer of records of the input DataSet.

Parameters:

  • Columns: with this parameter we set which columns from incoming dataset from InDataSet input will be displayed on the Table control. It is important to add a column, which exists in the incoming dataset from InDataSet input, its name to be written in the same way and to be of the same type. For example, if the incoming InDataSet is connected with an output of a block DBFStorage and the DBF has a column with name X of the analogue type, then in the Columns parameter of the DataSetTable block we must also add a column named X of the same signal type.

We can add columns from analogue, digital, integer, string, DataTime data types as is shown below.

 Every column has the next settings:

- Name - the name of the DataSet column;

- Grid column text - This text will appear as column name at the Table control. If this setting is empty, the Name will appear as text at grid column;

- Column width - the width of the column at Table control;

- Visible - we can show/hide the column. If we need the column as Output of the block, but we not want to see the column at the Table control, we have to uncheck this setting;

For analogue column we can set a format setting for cells at column - Digits after decimal separator. For DataTime column the format setting is a Date time format, we can set it manually or to choose from one of the existing formats at combobox and to press the button Set;

  • OnReloadGoTo - sets which row to be selected when the block's input Reload becomes to High level or the diagram is just started. Posible values are Top, Botom, Nothing - means No action, SelectedRow - means the block will get the value of input SelectedRow and will select this table's row;
  •  Connect to table - the block has to be connected with Table control;

 

Block's inputs:

  • InDataSet - the input DataSet.
  • Reload - when the input InDataSet is changed, the input Reload has to become to high level, then the Table control will be refreshed with new DataSet values;
  • SelectedRow (Ingeter data type) - the index of the row to be selected;
  • SetSelectedRow - when the input becomes to high value, the block gets the value of the input SelectedRow and selects this row;
  • GoTop - when the input becomes to high value, the top row of the Table control will be selected;
  • GoBottom - when the input becomes to high value, the top row of the Table control will be selected;
  • Disable - disables the Table control;

 

 Block's outputs:

  • CurrRow - (Integer data type) the index of the current selected row;
  • OnSelChanged -the output becomes on high value when the user changes mannualy the Table's row;
  • OnReloaded - when the Table control is refreshed;
  • Every added column at the Columns property appears as block's output;

 

Blocks DataSetComboBox, DataSetListBox:

License: Hobby, Industrial

The blocks have the same behavior, input and outputs as the DataSetTable block. The difference is that when adding the columns to the Columns parameter, only one of them can be marked as Shown. This means that the contents of the ComboBox/ListBox will be filled in with the values of this DataSet column. The number of rows in the control is the same as the records in the input InDataSet. Each added column will appear as the block output. When selecting a new row from the ComboBox/ListBox, the block outputs will accept new values from the corresponding InDataSet record. 

 

Block Chart:

License: Industrial

The block allows visualization of more than one signals together in Chart control. The InDataSet input must be connected to the output of a block containing data, such as DataSetStorage, DBFStorage, SQLSelect.

Parameters:

  • Chart - sets the Caption and Type of the visualization of the Chart control.

Chart Type may be one of the following:

  • Series - with this parameter we set which columns from incoming dataset from InDataSet input will be displayed on the Table control. It is important to add a column, which exists in the incoming dataset from InDataSet input, its name to be written in the same way and to be of the same type. For example, if the incoming InDataSet is connected with an output of a block DBFStorage and the DBF has a column with name X of the analogue type, then in the Series parameter of the Chart block we must also add a column named X of the same signal type.
    One of the added columns must be declared as Leading (checked at the first column at DataSet editor interface), this means that it will be shown on X axis, all others will be on the Y axis.

 

  • Use UpperLimit - if this parameter is checked, all the signals with values over UpperLimitValue will be shown in color from parameter UpperLimitColor;
  • UpperLimitValue;
  • UpperLimitColor;
  • Disable - the block will not work at started diagraml
  • Connect to ChartControl - the block has to be connected with Chart control;