Data Record at Index
Last updated
Last updated
Data Record at Index
is an that provides an object representing the at a specified index, after a successful read operation by the , and blocks.
NOTE: This block will provide valid values only after the , and blocks complete their execution. The block can be used to track the completion.
The block consists of the following (from top to bottom):
e.g. If the number of records read was 10, then the valid values are from 0 through 9.
The If
block to confirm that the value of the variable a (number of records read) was at-least 1
.
The result for the above example is shown in the image below.
Table: that accepts a value representing the name of the .
Dataset Name: that accepts a value representing the name of the dataset on which a database read was conducted using the Data Read, Data Read Next Page and Data Read Previous Page blocks.
Index: that accepts a integer values representing the index for which you want the data. The valid values are for the index are from 0 to Number_of_records_Read - 1. More on this topic below.
The index used to retrieve the data uses . Hence the valid values start at 0 and end at 1 less than the total count.
NOTE: Please refer to the prerequisite information shown before seeing the example.
The image below shows an example of the Data Record at Index
block. This example incorporates the Usage Example function, as outlined in the on the prerequisite information page mentioned above.
To begin, the output of the block is assigned to the variable a
. Note that the Customers along with the dataset name of ds1 are used for the .
The output of our Data Record at Index
block is assigned to the variable b
. Again note that the Customers along with the dataset name of ds1 and Index set to the value 0, are used for the .
The block is used to display the values of the FirstName and LastName properties of variable b
.
Data Record at Index
block