Using a Trigger to Auto-Generate a Key Value

发表于:2007-06-08来源:作者:点击数: 标签:
This example employs a trigger program to automatically generate a unique employee number every time a new record is added to an Employee Master File called EMPLOYEE. Example: Using a Trigger to Auto-Generate a Key Value This example emplo
This example employs a trigger program to automatically generate a unique employee number every time a new record is added to an Employee Master File called EMPLOYEE.

Example: Using a Trigger to Auto-Generate a Key Value

This example employs a trigger program to automatically generate a unique employee number every time a new record is added to an Employee Master File called EMPLOYEE. The file contains fields you would expect to see in a simple employee file, such as employee number, name, address, job code, salary, etc. Figure 6.1 shows the complete layout for the file.

Click To expand
Figure 6.1: This Employee Master File is used to demonstrate trigger usage.

原文转自:http://www.ltesting.net