Sync a Servoy sequence with database from Javascript code.

Classic Servoy
1

Sometimes it is much more efficient to do multiple inserts into a table entirely on the database server, such as inserting from a select statement. But, if the insert table contains a Servoy managed sequence, this sequence must be synced with the now updated table’s maximum value for that column. There appears to be no way to do this from Javascript code in Servoy. Maybe this can be a method added to the Database Manager?

Thanks!

2

That could possibly result in a chaos if clients are connected, so I think you cannot expect that addition. In such a situation it is better to not use Servoy sequences. Servoy sequences can only be used (in my eyes) if you are 100% sure that your Servoy app is the only application inserting data…