DB Navigator (part of Database Controls) in R:BASE 7.6 for Windows Form Designer, lets the user control the dataset when inserting, deleting, editing or viewing the data in forms.

You can also use DB Navigator control on forms that contain data-aware controls, such as DB Grid or DB Edit.

When the user chooses one of the DB Navigator buttons, the appropriate action occurs on the dataset to which the navigator is linked. For example, if the user clicks the Insert button, a blank record is inserted in the dataset.

DB Navigator can show any or all of the following buttons:

First

Sets the current record to the first record in the dataset, disables the First and Prior buttons, and enables the Next and last buttons if they are disabled.

Previous

Sets the current record to the previous record and enables the Last and Next buttons if they are disabled.

Next

Sets the current record to the next record and enables the First and Prior buttons if they are disabled.

Last

Sets the current record to the last record in the dataset, disables the Last and Next buttons, and enables the First and Prior buttons if they are disabled.

Insert

Inserts a new record before the current record, and sets the dataset into Insert and Edit states.

Delete

Deletes the current record and makes the next record the current record.

Edit

Puts the dataset into Edit state so that the current record can be modified.

Save

Writes changes in the current record to the database.

Cancel

Cancels edits to the current record, restores the record display to its condition prior to editing, and turns off Insert and Edit states if they are active.

Refresh

Refreshes the buffered data in the associated dataset.

DB Navigator Properties includes the following options:

Size and Coordinates (Top, Left, Width, Height):

Top

Specifies the Y coordinate of the top left corner of a control, relative to its parent or containing control in pixels.

Left

Specifies the horizontal coordinate of the left edge of a component relative to its parent.

Width

Specifies the horizontal size of the control in pixels.

Height

Specifies the vertical size of the control in pixels.

Align (None, Client, Left, Right, Top, Bottom):

Default: None

Specifies an alignment of DB Navigator control and how the control is placed relative to its parent. It can have one of the following values

None

The control remains where it was placed. This is the default value.

Client

The control resizes to fill the client area of its parent. If another control already occupies part of the client area, the control resizes to fit within the remaining client area.

Left

The control moves to the left side of its parent and resizes to fill the height of its parent. The width of the control is not affected.

Right

The control moves to the right side of its parent and resizes to fill the height of its parent. The width of the control is not affected.

Top

The control moves to the top of its parent and resizes to fill the width of its parent. The height of the control is not affected.

Bottom

The control moves to the bottom of its parent and resizes to fill the width of its parent. The height of the control is not affected.

Flat (True/False):

Default: False

Determines whether the buttons of the navigator have a three-dimensional (3-D) look with borders or two-dimensional look without borders. When Flat is set to True (checked), the navigator buttons appear flat and do not have borders separating them. When Flat is False (un-checked), the buttons are clearly defined.

Visible Buttons

Determines which buttons appear on the DB Navigator. The buttons are:

·

First

·

Previous

·

Next

·

Last

·

Insert

·

Delete

·

Edit

·

Save

·

Cancel

·

Refresh

All buttons have the option of True/False and the default is set to True.

Use Visible Buttons to select which buttons appear on the DB Navigator. Un-check (set to False) any of the navigator buttons out of the Visible Buttons set to hide those buttons and thereby prevent the user from performing certain operations. For example, to only allow the user to view the records in the dataset, Visible

Buttons should include only the First, Previous, Next, and Last.

Table Name

To associate table data set.

Default: Form TableName

Hints

Provides a way to customize the Help Hints for each button on the DB Navigator. Use the Hints property to supply Help Hints of your choosing for the individual navigator buttons.