Database Navigator

Database Navigator object is a tool for navigating, adding and deleting the database records on a form.

Settings

Table defines the database table which should be navigated using the Database navigator object.

Database navigator commands differ according to the initial state of the selected database table on form startup: Read-and-Write or Read-only. The first one allows editing action, whereas the second one prevents the user from making any changes on the connected database.

Read-and-Write mode commands are (from left to right):

• First record: places you on the first record of the connected database table.

• Prior record: places you one record back.

• Next record: places you one record further.

• Last record: places you on the last record of the connected database table.

• Insert record: inserts a new record in the connected database table.

• Delete records: deletes a record in the connected database table.

• Post edit: posts the changed record in the connected database table.

• Cancel edit: cancels the record editing and discard any changes done.

• Refresh data: refreshes the displayed data in the connected database table.

Read-only mode includes a reduced set of commands:

• First record: places you on the first record of the connected database table.

• Prior record: places you one record back.

• Next record: places you one record further.

• Last record: places you on the last record of the connected database table.

• Refresh data: refreshes the displayed data in the connected database table.

Position

Position tab defines object positioning and its position-related behavior.

Position group defines the object position.

• X and Y: anchoring point coordinates.

• Width and Height: horizontal and vertical object dimension.

• Keep aspect ratio: simultaneous changing of object dimensions while scaling.

• Lock: prevents the object from being moved during the design process.

Size group sets how object's dimensions change when the form is running:

• Resize anchor point: defines the fixed distance of an object from the form borders.

  Tip

  Choose the most appropriate anchor point to ensure the object's visibility regardless of the current window size.

• Horizontally resize with form and Vertically resize with form: object size automatically adapts to the changing size of the form.

  • Horizontally resize with form: object width adapts to the resized form.

  • Vertically resize with form: object height adapts to the resized form.

    Note

    If both options are enabled, object width and height adapt to the resized form simultaneously.

Rotation angle group sets the object angle according to the design surface.

General

General tab defines the object and defines object settings for form startup.

Name sets a unique object ID. It is used for object referencing when defining functions, variables, scripts, etc.

Description allows adding notes and annotations for an object.

Hint helps the form users by briefly explaining why or how to use the selected object.

Initial state on form setup group defines the object behavior while editing and printing a form:

• Enabled: defines if the object is going to be active (editable) on the print form or not.

  • Condition: an object is enabled if the result of the given condition is "True".

• Read-only: prevents connected data source input and content editing.

• Visible: defines if the selected object is going to appear on the form or not.

  • Condition: an object is visible if the result of the given condition is "True".