Skip to Content
0
Former Member
Dec 02, 2008 at 09:44 PM

Auto sequencing of custom tables

283 Views

Hi All,

I need to create a custom table wich will have a serial number as the primary key. Whenever the table is updated with new entries this serial number needs to be incremented by 1. I wanted to know if there is any procedure to auto generate this serial number. I do not want to do the max of the serial number and increment it by 1 because it will lead to problems when more than one person is updating the entries exactly at the same time. I dont even want to go for date and timestamp, I want serial numbers such as 1,2,3 and etc. or something similar. Please let me know how to achieve this.

Thanks in advance.