Executing database action

Last Updated : Oct 13, 2020 |

About this task

The Database Execute Action contains a query against the open database, in this example it concerns the ISBN captured in the previous menu action. If the sequence of numbers entered by the caller matches an ISBN entry in the database, then the Author's name, cost, ISBN and book title details are captured. This query is entered into the Database Execute Action via the specific tab. When entering information into the specific tab for the first time you are taken through a series of steps.

Procedure

  1. Select the Database Open Icon required. In this example the 'Make sure Database still active' icon was selected.
  2. At the SQL Function window the option to 'Select …From' was chosen as information from the database is required.
  3. Details are then entered into the SQL Wizard, as shown below.
  4. When the query has been entered the SQL wizard is closed. The specific tab of the action will contain the entered query, see example shown below.