22 - 11 - 2019

DataSet Conception

DataSet is an extremely powerful and fast tool that gives you easy access to database, graphs, tables, etc.
 
The yellow colored input or output of a block is a special type of signal called DataSet. It is a database at memory with unlimited number of columns and rows (records). The main attributes of each column are:
  • Name - must be unique within DataSet;
  • Comment - text with which the column will be displayed in graphics, tables, etc .;
  • Type - type of data in the column, can be analog, digital, integer, string;

For different types of blocks, the column may has some specific additional settings, for example, for the graphics block, each column has the color of the curve, the point size. For the analog columns - minimum and maximum values in the graph, etc. For Dataset preview block in a table, there are settings for formatting the cell text for each column. For example, the columns with analog values there are additional settings by how many characters are displayed after the comma. For the digital columns, you can set what is the text for TRUE and for FALSE values of the cell. For example the texts can be ON/OFF or Yes, No.

Concatenating two DataSets - when a block has DataSet in it and has a DataSet input, then the block usually has a digital input that, when passing to a high level, records from the input DataSet of the block are added to the existing DataSet records of the block itself. When concatenating, only data from columns with the same names is transferred. Ie. if there is 5 columns in the input DataSet, there are 10 columns in the DataSet receiver and of these two columns groups only 3 columns match names, only their values will be transferred. If there is a difference in the types of signals in the columns with the same names from input DataSet and DataSet receiver, they will be automatically converted from one type to another. The columns in the DataSet receiver, which are not found by name in the DataSet source, will be blank when copying.