The UiTable class implements the UiTable development environment component that grants access to database tables.
Property name | Brief description | |
Database | The Database property determines the repository database that stores data sources. | |
Exists | The Exists property determines whether the table exists in the database. | |
ReadOnly | The ReadOnly property determines whether table data can be edited. | |
TableName | The TableName property determines the physical name of the table, which should be accessed. |
Property name | Brief description | |
Active | The Active property determines whether the component is active. | |
Bof | The Bof property returns True if the cursor in the data source is on the first record. | |
CachedDataset | The CachedDataset property returns cache of the data source. | |
Eof | The Eof property returns True if the cursor in the data source is on the last record. | |
Fields | The Fields property returns the table fields collection. | |
Filter | The Filter property determines the data filtering condition. | |
Filtered | The Filtered property determines whether active data set should be filtered. | |
RecNo | The RecNo property determines the number of the current record in the data source. | |
RecordCount | The RecordCount property determines the number of the records in the data source. | |
State | The State property returns the current state of the data source. |
Property name | Brief description | |
ComponentCount | The ComponentCount property returns the number of child components located on the parent component. | |
Components | The Components property returns a child component, which index is passed via the input parameter. | |
Data | The Data property is used to store any custom data. | |
Name | The Name property determines the component name. | |
Tag | The Tag property is not used by the compiler. The user can change the value of this property and use it at his discretion. |
Method name | Brief description | |
The Append method adds an empty record in the beginning of the table. | ||
The Cancel method cancels the changes made to the current record. | ||
The Close method closes data source. | ||
The Delete method deletes the current record. | ||
The Edit method switches the current record to the edit mode. | ||
The FieldByName method searches for a field by name. | ||
The First method places the cursor onto the first record in the data source. | ||
The IsEmpty method returns True if the data source is empty. | ||
The Last method places the cursor onto the last record in the data source. | ||
The MoveBy method moves the cursor in the data source and returns the number of records, by which the cursor has moved. | ||
The Next method places the cursor onto the next record in the data source. | ||
The Open method opens the data source. | ||
The Post method saves the changes that are made to the current record of the data source. | ||
The Prior method places the cursor onto the previous record in the data source. | ||
The Refresh method refreshes the component data. | ||
The Truncate method clears all the records from the data source. |
Event name | Brief description | |
OnAfterClose | The OnAfterClose event occurs after the data source is closed. | |
OnAfterOpen | The OnAfterOpen event occurs after the data source is opened. | |
OnAfterScroll | The OnAfterScroll event occurs after moving by records in the data source. | |
OnBeforeClose | The OnBeforeClose event occurs before the data source is closed. | |
OnBeforeOpen | The OnBeforeOpen event occurs before the data source is opened. | |
OnBeforeScroll | The OnBeforeScroll event occurs before moving by records in the data source. |
See also: