Problem solve Get help with specific problems with your technologies, process and projects.

How do I simulate an auto-increment field in a Domino database?

How do I simulate an auto-increment field in a Domino database?
Because of the distributed nature of Notes applications, where you can have different replicas on different servers or even on a user's local hard drive, assigning a unique sequential number as a document is being composed is not as straightforward as in a single-server, relational environment. This topic has been discussed extensively in the Notes 4 & 5 forum on LDD. Go there and search for "sequential numbering" and I think you will find dozens of solutions, applicable to different situations.

Incidentally, in my experience designing Notes applications, I've found that very often a requirement initially stated as a sequential identifier, can be satisfied with a value that's not sequential but merely unique (e.g., using the @Unique function).

Dig Deeper on Lotus Notes Domino Application Development

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.




  • iSeries tutorials

    Search400.com's tutorials provide in-depth information on the iSeries. Our iSeries tutorials address areas you need to know about...

  • V6R1 upgrade planning checklist

    When upgrading to V6R1, make sure your software will be supported, your programs will function and the correct PTFs have been ...

  • Connecting multiple iSeries systems through DDM

    Working with databases over multiple iSeries systems can be simple when remotely connecting logical partitions with distributed ...