Sidebar
DATABASE ACTION
Guide Section: Processing Events and Performing Actions
EASAP Tree:
EVENT PROCESSING → ACTION / PROCESSES
DATABASE ACTION initiates read and write actions on one or more databases as specified in Child DATABASE objects.
An individual Child READ or a Child WRITE to a DATABASE encapsulates an SQL query.
A READ can occur either in a DATA PROCESSING or as a ACTION within an EVENT PROCESSING.
When used as ACTION's the Outputs: parameter of READ are explicit objects.
 DATABASE ACTION |
|
|---|---|
| Optional Parameters: | |
| Do if: | logical expression, if FALSE then action NOT performed else default→TRUE. |
| PROCESSES branch only | |
| On Error: | specify whether subsequent ACTION's or PROCESSES are run if error occurs (default→Continue, Stop) |
| Child objects under DATABASE ACTION | ||
|---|---|---|
| DATABASE | define the database on which to perform the action | |
 CLOSE CONNECTION | after a READ/WRITE sequence close the database connection |
|
| READ | execute a SELECT statement in SQL | |
 WRITE | execute an INSERT, UPDATE or DELETE | |