UiQuery

Description

The UiQuery class implements the UiQuery development environment component that is used to access data by SQL queries.

Properties inherited from IUiQuery

	Property name	Brief description
	Database	The Database property determines the repository database that stores data sources.
	ParamCheck	The ParamCheck property determines whether the query parameters list is generated again if the SQL and Database properties were changed during the program execution.
	Params	The Params property determines the collection of query parameters.
	SQL	The SQL property determines the text of the SQL query to the database.

Properties inherited from IUiDataSet

	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.

Properties inherited from IComponent

	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.

Methods inherited from IUiDataSet

	Method name	Brief description
	Append	The Append method adds an empty record in the beginning of the table.
	Cancel	The Cancel method cancels the changes made to the current record.
	Close	The Close method closes data source.
	Delete	The Delete method deletes the current record.
	Edit	The Edit method switches the current record to the edit mode.
	FieldByName	The FieldByName method searches for a field by name.
	First	The First method places the cursor onto the first record in the data source.
	IsEmpty	The IsEmpty method returns True if the data source is empty.
	Last	The Last method places the cursor onto the last record in the data source.
	MoveBy	The MoveBy method moves the cursor in the data source and returns the number of records, by which the cursor has moved.
	Next	The Next method places the cursor onto the next record in the data source.
	Open	The Open method opens the data source.
	Post	The Post method saves the changes that are made to the current record of the data source.
	Prior	The Prior method places the cursor onto the previous record in the data source.
	Refresh	The Refresh method refreshes the component data.
	Truncate	The Truncate method clears all the records from the data source.

Events inherited from IUiDataSet

	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:

ExtCtrls Assembly Classes