Description
The Dataview object, available from release 2015.03, allows read-only view of the data retrieved from the database using a query.
Specific properties
In addition to common properties contains the following properties:
BrowseQuery: It contains the query used to display the data. Such queries can contain parameters whose names, preceded by the character “:”, may correspond to field names linked to objects on the form or object names. Upon opening of the form, the query will be executed and will be assigned the parameters to field values and / or objects.
Specific events
- ChangeRowEvent
Event triggered with every change of the row selected by the user.
It can be used to take actions such as upgrading of other objects on the form based on the values of the row on which you have placed.
For more information about Events click here.
Properties that can be used by code
C/S Properties
None
Web properties
None
Methods that can be used by code
- Count(): It returns the total number of lines in the grid.
- EndOfRows: It returns true if the current row pointer is beyond the last row
- MoveFirst(): move your pointer to the rows on the first line, returning false if the operation failed, for example because there are no lines
- MoveLast(): move your pointer to the rows on the last line, returning false if the operation failed, for example because there are no lines
- MoveNext(): move your pointer to the rows on the line after the current one, returning false if it was the last line and the pointer it went beyond the end of the set of lines
- MovePrevious(): move your pointer to the rows on the line before the current, returning false if it was on the first line and the pointer he went before the start of the set of rows.
- ReadField(<field>): It returns the value of the specified field in the parameter, for the current row.
- setVisible(<bool>): if it called setting false, hides the grid, if you pass true displays it.