Transaction Processing

Type

Concept

Purpose

Transaction processing is a technique that lets you enter, modify, and delete records in multiple tables using input from a single form. A transaction processing procedure lets you update the information in the database without having to physically enter the data into each form in record entry mode. Because it saves time and reduces the possibility of keying errors, transaction processing is widely used for point-of-sale applications to automate customer billing and inventory maintenance.

Usage

With DataEase, each transaction is entered using a Data-entry form or an input using command. After the data is entered, it is processed by a predefined DQL Procedure that automatically posts the information into the appropriate related tables.