DataGrid
The DataGrid control allows you to interact with and edit the rows and columns of a Dataset in a customisable grid. See: DataGrid
Note that while the DataGrid control inherits much of the functionality of a Data View, including a date picker for Date fields, the following are not currently supported:
- Picklists (the ability to select a lookup code from a list)
- A special editor for Image BLOB fields
If this functionality is needed, use a Data View instead.
Scripting Syntax
The DataGrid control allows you to interact with and edit the rows and columns of a Dataset in a customisable grid. See: DataGrid
To navigate the rows and columns in the grid use the following scripting syntax:
dataset = FormRuntime.Datasets[“NameofDataset”]
dataset.CurrentIndex = 3
dataset.MoveFirst()
dataset.MoveBack()
To manipulate the rows and columns in the grid use the following syntax:
dataset.RowChanged +- ...
dataset.Add()
dataset.Delete()
dataset.Refresh