progress openedge table auto increment?

Question

I have a table in progress db. (read: NOT POSTGRES). it has three columns, and I would like one of the column to be auto increment begins at 1 and increment by 1. Tried the following syntax but it does not see to be working.

create sequence pub.Customer_sequence
  start with 1, 
  increment by 1,
  nocycle;

the error message says:

Unable to understand after "Customer_sequence"

could not understand line 2

Tom Bascom Tom Bascom · Accepted Answer · 2016-06-28T18:44:38

Progress is not SQL. Some small amount of SQL-89 is included but it is not generally considered useful.

There is nothing in Progress equivalent to an auto-increment field. To get that functionality you might use a combination of CREATE trigger and a SEQUENCE.

You can find an example of a create trigger that uses a sequence in $DLC/sports/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).

progress openedge table auto increment?

2 Answers