Altering Databases - Advanced Tab
Specifies how locking is handled in the database and specifies the start ID for elements on new objects.
To open this window, on the File menu, choose Database, choose Alter, and then choose the Advanced tab.
Locking Options
Field | Description |
---|---|
Lock timeout |
Specifies whether a session waits to place a lock on a resource that has already been locked by another session. If you clear this field, then the session waits indefinitely. |
Timeout duration (sec) |
Specifies the maximum length of time that a session waits to place a lock on a resource that has already been locked by another session. The default value is 10 seconds. |
Designer Options
Field | Description |
---|---|
Start ID (UidOffset) |
Specifies the start ID for elements on new objects. When you create a new table, page, report, codeunit, query, or XMLport, the elements have IDs that are offset by the Start ID (UidOffset) value that you specify. Object elements include containers, groups, fields, parts, DataItems, columns, filters, variables, functions, or text constants. You must specify an Integer that is greater than or equal to 0. The default value is 1. |
See Also
Tasks
How to: Alter Databases
How to: Specify the Start ID Offset of Elements on Objects
Concepts
Altering Databases - General Tab
Altering Databases - Database Files Tab
Altering Databases - Transaction Log Files Tab
Altering Databases - Collation Tab
Altering Databases - Options Tab
Altering Databases - Integration Tab