sequences for composite (compound) keys

Classic Servoy
1

We encounter problems with the Servoy sequences which are set for all primary key attributes by default. This is fine - a good guess - for all artificial keys. But for composite keys this is almost always wrong.

So, a sequence should not be set for a table which has more than 1 pk attribute, as this is practically always wrong. In other words, if no sequences are set for tables with composite (compound) keys, it’s quite sure that this is 99.9% right.

We would appreciate a change in a future release of Servoy accordingly.

Now we have to change these settings in the Servoy Developer whenever we run an import (about 150 tables). This is time consuming and error-prone. And we are far away from an automated process.

Regards

Birgit Rieder
Robert Huber

2

I completely agree, you always have to change this.

A different default would be nice.

3

Hi

Servoy column info initialisation has been changed as suggested.
Servoy-sequence columns will only be created on new tables with a single numerical pk.

This change is part of Servoy 3.5 and will be introduced in release 3.5 beta 3.

Rob

4

Wow, that’s great! We are looking forward to that.

Thanks and regards
Birgit Rieder