2 years ago

How to implement sequential numbers for records

Posted 2 years ago by rabol


Is there a easy way to implement sequential numbering for records?

What I need is:

on a table i have a string field, let's say seqId

and in every form I would like to initialise the field with the next number in in the sequence, but as the same time format it like INV-000001, INV-000002 etc.

It should be DB independent :)

Thanks in advance

Please sign in or create an account to participate in this conversation.