https://bugs.documentfoundation.org/show_bug.cgi?id=130345
--- Comment #10 from mhonline <[email protected]> --- the concept of having no record-numbers "available for users" in firebird is weak, althought they need to have them, since they can establish table-relations. However, the proposal of robert might not work, as the value from "generated by default" can be overwriten. Pls see this copy from the FB-4.0-manual: GENERATED BY DEFAULT An identity column of type GENERATED BY DEFAULT will generate a value on insert if no value — other than DEFAULT — is specified on insert. When the OVERRIDING USER VALUE clause is specified in the INSERT statement, the user-provided value is ignored, and an identity value is generated (as if the column was not included in the insert, or the value DEFAULT was specified). But the solution for the problem lies somewhere in there. I still believe, that - as stated somewhere else - the field of type identity with autoincrement must be made "non-editable" by user, but to have additional regular fields filled by a generator might be an option too to get a usable workaround. m. -- You are receiving this mail because: You are the assignee for the bug.
