I've googled and i have not come across the steps on actually locking a record. I have a DB that I would autogenerate serial numbers. The sites i've come across explains that I will need to have a one field table with the number i will be using, I got that. But it then explains "When a new sequence number is needed, retrieve the number. Lock the table so no other user can pull the same number until the current number is used. This will prevent duplicate numbers and breaking the sequence."
Help