Component List

This topic presents a brief description of the components included in the SQLite Data Access Components library. Click on the name of each component for more information. These components are added to the LiteDAC page of the Component palette except for TCRBatchMove and TVirtualTable components. TCRBatchMove and TVirtualTable components are added to the Data Access page of the Component palette. Basic LiteDAC components are included in all LiteDAC editions. LiteDAC Professional Edition components are not included in LiteDAC Standard Edition.

Basic LiteDAC components

	TLiteConnection	Represents an open connection to a SQLite database.
	TLiteQuery	Executes queries and Operates record sets. It also provides flexible way to update data.
	TLiteSQL	Executes SQL statements, which do not return rowsets.
	TLiteTable	Lets you retrieve and update data in a single table without writing SQL statements.
	TLiteUpdateSQL	Lets you tune update operations for the DataSet component.
	TLiteDataSource	Provides an interface between LiteDAC dataset components and data-aware controls on a form.
	TLiteScript	Executes sequences of SQL statements.
	TLiteSQLMonitor	Interface for monitoring dynamic SQL execution in LiteDAC-based applications.
	TLiteConnectDialog	Used to build custom prompts for the database name and encryption key.
	TVirtualTable	Dataset that stores data in memory. This component is placed on the Data Access page of the Component palette.
	TVirtualDataSet	Dataset that processes arbitrary non-tabular data.

LiteDAC Professional Edition components

	TLiteUserCollation	Provides functionality for working with user-defined collations
	TLiteUserFunction	Provides functionality to define custom functions for future use in SQL-statements
	TLiteLoader	Provides quick loading of external data into the database
	TLiteDump	Serves to store a database or its parts as a script and also to restore database from received script.
	TLiteBackup	Implements SQLite Online Backup API functionality
	TLiteMetaData	Retrieves metadata on specified SQL object.
	TLiteEncryptor	Represents data encryption and decryption in client application.
	TCRBatchMove	Retrieves metadata on database objects from the server.

See Also

• Hierarchy chart