Auto Increment

[anandknr]

Is there any way to implement auto increment functionality to a field in progress table?

 

[rstanciu]

take a look to table sports2000.Customer , field CustNum,
there is a sequence NextCustNum and a trigger on create.

 

[RealHeavyDude]

There is no auto-increment feature available in the database - you need to roll your own in your business logic.

Such requirements are usually solved in using sequences and some code that uses that sequences in the business logic. Usually such code is placed in database triggers. If you place that code in a database trigger then you should be aware that these triggers are only available when you access the database with an ABL client.

Heavy Regards, RealHeavyDude.