Register
Sign In
Concept
Purpose
A DQL Processing procedure can enter, delete, and modify records, as well as create screen, disk, or printed output based on the script instructions, the data stored in database tables, and additional data input during the execution of the procedure.
Usage
The Processing commands (shown at right) are primarily used to create a Processing procedure. These commands can also be used in a Control procedure.
Example
TOTAL DUE .
This script tells DataEase: (1) Process all the MEMBERS records, and (2) for each record processed, list the LAST NAME and the TOTAL DUE values and arrange the output in alphabetical order by LAST NAME.
Note: When accessing data in an SQL database, DataEase treats a Processing procedure as a single transaction, unless you use the DQL begin transaction and commit commands to divide the procedure into multiple transactions.
Product: . Written by alembagheri tahmas 07/12/13 at 13:37:32
Product: DataEase for Windows 7.x. Written by George Washington 11/04/14 at 08:26:17
Product: DataEase 8 Reporter. Written by eduardo paez 02/05/14 at 14:40:11
Product: . Written by Marco Marchesi 15/02/16 at 14:50:46
Product: Dataease [{8}]FIVE. Written by Chamil Rajindra 21/02/19 at 10:17:46
Product: . Written by afonso santos 28/10/19 at 00:50:14
Product: . Written by Grossi Gioacchino 18/11/19 at 14:33:44
Product: Dataease [{8}]FIVE. Written by Rainer 22/03/21 at 11:13:10
Product: Dataease [{8}]FIVE. Written by Rainer 08/06/21 at 14:12:40
Product: . Written by Hiralal Rampul 01/12/21 at 17:47:10
Copyright © DataEase Limited. All Rights Reserved
