DataView (gb.db.form)

This control implements a TableView that shows the contents of a database table and allows to edit it.

The data is provided by the the first DataSource parent control.

The Columns property controls the list of fields to display or edit.

Properties

Background	Returns or sets the background color used by the control.
Border	Return or set if the control has a border.
Columns	Return or set the fields displayed by the control.
Count	Return the number of records.
Current	Return the values of all primary keys of the current record as an array of Variant.
Data	Use this property to store the contents of a cell during the Data event handler.
Editable	Return or set if the DataView contents is editable.
Font	Returns or sets the font used to draw text in the control.
Grid	Returns or sets if grid lines should be displayed.
Header	Return or set which headers should be displayed:
Highlight	Return or set if even lines are highlighted.
Index	Return the index of the current record.
Labels	Return or set the labels that will replace the field names in the column headers.
Mode	Return or set the selection mode:
Sorted	Return or set if the control can be sorted by clicking on the column headers.
View	Return the underlying TableView used for displaying and editing the data.

Action	Returns or sets the action string associated with the control.
Children	Returns a collection of each control included in the container.
ClientH	A synonymous for the ClientHeight property.
ClientHeight	Returns the height of the area containing the controls.
ClientW	A synonymous for the ClientWidth property.
ClientWidth	Returns the width of the area containing the controls.
ClientX	Returns the position of the left border of the area containing the controls.
ClientY	Returns the position of the top border of the area containing the controls.
Cursor	Use this property for assigning a custom cursor to a control.
Design	Indicates that the control is in design mode.
Direction	Return or set the control text direction.
Drop	Returns or sets if a control accepts drops.
Enabled	Indicates that the control is enabled.
Expand	Returns or sets if a control will expand if included in a container that arranges its contents.
Foreground	Returns or sets the foreground color used by the control.
H	A synonymous for the Height property.
Handle	Returns the internal X11 window handle of the control.
HasFocus	Returns whether the control has the focus.
Height	Returns or sets the height of the control.
Hovered	Returns whether the mouse cursor is inside the control.
Id	A synonymous for the Handle property.
Ignore	Returns or sets if a control must be ignored when its parent arranges its children.
Left	Returns or sets the position of the left border of the control relative to its parent.
Mouse	Returns or sets the appearence of the cursor when it points inside the control.
Name	Returns or sets the name of the control.
Next	Returns the next control having the same parent.
NoAnimation
NoTabFocus	Return or set if a control cannot be focused with the TAB key.
Parent	Returns the control container.
PopupMenu	Return or set the name of the menu that will be popped-up when the user presses the right mouse button or the keyboard MENU key.
Previous	Returns the previous control having the same parent.
Proxy	Return or set the "proxy" of a control.
ProxyFor	Return which control that control is a proxy for.
RightToLeft	Return if the control is right to left oriented.
ScreenX	Returns the position of the left border of the control in screen coordinates.
ScreenY	Returns the position of the top border of the control in screen coordinates.
Tag	Returns or sets the control tag.
Tooltip	Returns or sets the tooltip shown when the mouse stays on the control for a short time.
Top	Returns or sets the position of the top border of the control relative to its parent.
Tracking	Returns or sets if the control will receive MouseMove events.
Visible	Indicates if the control is visible or not.
W	A synonymous for the Width property.
Width	Returns or sets the width of the control.
Window	Returns the top-level window that contains the control.
X	Returns or sets the position of the left border of the control relative to its parent.
Y	Returns or sets the position of the top border of the control relative to its parent.

Methods

Cancel	Cancel the current record edition.
Create	Enter creation mode.
Find	Find the first row matching a SQL request and move to it.
FindNext	Find the next row matching a SQL request from the current position, and move to it.
MoveFirst	Move the current record to the first one.
MoveLast	Move the current record to the last one.
MoveNext	Move the current record to the next one.
MovePrevious	Move the current record to the previous one.
MoveTo	Move the current record to the Indexth one.
Remove	Delete the selected records, and return TRUE if is has not been possible.
Save	Save the current record and return TRUE if it has not been possible.
SelectAll	Select all rows.
UnselectAll	Unselect all rows.
Update	Reload the DataView contents.

Delete	Destroys the control.
Drag	Starts a drag & drop process.
FindChild	Finds the first child control pointed by the X and Y coordinates.
Grab	Grab the keyboard and the mouse so that all keyboard and mouse events are received by the control.
Hide	Hides the control.
Lower	Sends the control to the background of its parent.
Move	Moves and/or resizes the control.
MoveScaled	Moves and/or resizes the control.
Raise	Sends the control to the foreground of its parent.
Refresh	Trigger a redraw of the control.
Reparent	Changes the container of a control.
Resize	Resizes the control.
ResizeScaled	Resizes the control.
SetFocus	Gives the focus to the control.
Show	Shows the control.

Events

Activate	Raised when the current record changes.
Data	Raised when the DataView needs to display a specific cell.

Arrange	This event is raised when a container has just finished arranging its contents.
BeforeArrange	This event is raised just before a container arranges its contents.
DblClick	Raised when the user quickly clicks twice on the control.
Drag	This event is raised when the mouse enters the control during a drag & drop process.
DragLeave	This event is raised when the mouse leaves the control during a drag & drop operation.
DragMove	This event is raised while the mouse moves inside the control during a drag & drop process.
Drop	This event is raised when a drag is dropped in the control.
Enter	Raised when the mouse enters the control.
GotFocus	Raised when the control has got the focus.
KeyPress	Raised when a key is pressed while the control has the focus.
KeyRelease	Raised when a key is released while the control has the focus.
Leave	Raised when the mouse leaves the control.
LostFocus	Raised when the control has lost the focus.
Menu	Raised when the user clicks on the control with the right mouse button, or if it hits the MENU key.
MouseDown	Raised when a mouse button is pressed while the cursor is inside the control.
MouseDrag	This event is raised when a drag operation should be started.
MouseMove	Raised when the mouse moves inside the control while a mouse button is pressed.
MouseUp	Raised when a mouse button is depressed while the cursor is inside the control.
MouseWheel	This event is raised when the user moves or presses the mouse wheel while the mouse is inside the control.
NewChild	This event is raised when a new child Control has just been inserted into the container.

See also