On page 275 of the Server docs (Servoy 2.2.4) there’s a passing mention of “sequences”. Here’s the context:
When using a shared Repository, sequences and users are shared as well. That is not the case if
you use separate repositories.
What are sequences? What’s being discussed here and what are the implications of shared and non-shared sequences?
Appreciated.
Sequences are “auto-numbering” columns, usually primary keys (pk’s), where either the DB server or the Servoy App Server is given responsibility for automatically incrementing the pk each time a new row is created in the table.
If you use Servoy’s sequences (as opposed to your DB server’s sequences) then the “settings” for the sequence (table & column name, starting number & how much to increment by each time, etc.) are held in the repository.
The documentation is referring to a repository that is shared between the Servoy Developer and Servoy Server. It is telling you that in that situation, a row insertion from either Developer or Server will get assigned pk’s from the same sequence.
If the repository isn’t shared, then developer-initiated insertions will get assigned pk’s from the Developer repository’s sequence and server-initiated insertions will get pk’s from the Server respository’s sequence.