Databases Reference
In-Depth Information
An interactive edit section is displayed above the data grid when you select one of the Manage menu options.
This is shown in Figure
11-34
. The edit sections all contain their own Cancel and Apply buttons. You must click the
Apply button to save your change.
Figure 11-34.
Data-grid management, Data Grid Properties menu option
The Manage drop-down menu gives you a rich set of options that allow you to use a data grid as a simple and
friendly spreadsheet-like application. Most of the options are simple to use; they're illustrated in more depth in
Chapter 12. The Manage menu options are summarized next:
•
Properties
: Lets you edit the overall data-grid properties.
•
Toggle Checkboxes
: Toggles the row-selection check boxes on and off. The row-selection check
boxes are used to perform bulk updates on selected rows.
•
Columns
:
•
Add
: Adds a new column to the data grid.
•
Column Properties
: Changes the properties of a column after it has been created.
•
List of Values
: Creates a named list of values. A named list of values can be used in more
than one data grid.
•
Column Groups
: Creates column groups.
•
Validation
: Adds data-entry validations. You choose validations from a defined list of
business rules. You can use several validations simultaneously to achieve a result. For
example, to make sure a number is greater than zero, you use the Column Specified
Is NOT Zero validation together with the Column Specified Doesn't Contain Any of
the Characters in Expression validation, and you enter a minus-sign character in the
Validation Expression text area. This last point illustrates the fact that all of the underlying
data in a data grid is text—and that sometimes you need to use more than one validation
rule to achieve a single result.
