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