Reading data from databases
Naturally, the next stage is to access the data from our database. In this section, you will learn how to execute a SQL Select statement to retrieve data. A Select statement is commonly used among most databases.
Before we move on to the next section, let's disable our actions from the previous section. To do this, just click on the three dots on line 2, select the Disable action, and then click on Save. This is designed to ensure that it doesn't interfere as we proceed with reading the data.
To read data, we will need to create a Record type variable to store each record. In the following walk-through, you will run an aggregated Select statement against the sample Microsoft Access database in the GitHub repository. This Access database has a table called tblSales, and the structure of the table is shown in the following screenshot:
Figure 15.20 – Access database – table structure
For this walk-through...