Progress
Programming
Handbook


CREATE Schema Trigger Example

The following example CREATE schema trigger procedure uses a sequence called Next–Cust–Num to generate a unique number for creating a customer record. For more information on sequences, see Database Access."

crcust.p
TRIGGER PROCEDURE FOR Create OF Customer. 
/* Automatically Increment Customer Number using Next-Cust-Num Sequence */ 
ASSIGN Customer.Cust-Num = 
   NEXT-VALUE(Next-Cust-Num). 


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095