We’ve got a large solution (~60 tabels) and via button “onAction” events are calling stored procedures for all adding and deleting of all rows. (We’ve got create/delete Web access to part of the solution and started before the headless API was available.)
We’ve set all db sequences to “none”. Is there any difference or advantage to using “db identity” instead? What is the difference?
“There is also another autoenter option in Servoy called “databaseManaged”, this option specifies to Servoy that a column is filled for example by a database trigger (or something else) and Servoy should never update that column but only retrieve the data.”
Should we be using this autoenter feature for all db-managed keys/fields as well? (We’re currently not doing that at all.)