Monday, August 19, 2002
From The Edge: Understanding DB Navigator in Form Designer
Section: Form Designer
Chapter: Running R:BASE Your Way!
Platform: R:BASE 7.0 for Windows
Build: 1.855xRT03 and Higher
DB Navigator (part of Database Controls) in R:BASE 7.0 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.
PDF version of this technical document is also available at:
From The Edge: http://www.razzak.com/fte (Forms and EEPs)
(Powered by R:Tango)
Enjoy and make sure to have fun!
Very Best Regards,
Razzak.
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: INTRO rbase-l
================================================
TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: UNSUBSCRIBE rbase-l
================================================
TO SEARCH ARCHIVES:
http://www.mail-archive.com/rbase-l%40sonetmail.com/
