Introduction to Datasets module
The Dataset Module is designed for data exchange with SQL databases and text files from a diverse set of sources. This module offers compatibility with a wide array of database technologies, including ADO.NET, ODBC, OleDB, and native interfaces, providing straightforward configuration with prominent databases such as SQL Server, Oracle, SQLite, and PostgreSQL.
Features include multi-threaded concurrent connections for efficient data handling, a dedicated SQLite editor for streamlined database management, and an intuitive visual query builder that simplifies the process of query creation and manipulation. Moreover, the Dataset module is equipped to integrate real-time tags within query strings, enhancing the dynamism of data interaction. It can also manage files and recipes in ASCII, Unicode, or XML formats, broadening its applicability across different data types.
On this page:
Dataset Runtime Attributes
The Dataset namespace exposes properties and methods of the .NET objects used by the Dataset module execution.
For more information on namespaces and objects, go to Objects and Attributes.
Dataset module Properties examples | |||
|---|---|---|---|
Property | Type | Description | Example |
| Integer | Represents the current position of a cursor within the result set of a query. It is an integer value that indicates the row number in the result set that the cursor points to, with the first row having an index of 0. The cursor can be used to navigate through the result set, allowing you to read, update, or delete rows of data. | Dataset.Query.QueryName.CursorIndex + 1 |
| String | Provides a human-readable message describing the current state of the database connection. This can be useful for monitoring the connection status, diagnosing issues, or displaying the connection status to users in a user-friendly format. | Dataset.DB.DatabaseName.OpenStatusMessage |
| String | Used to store the necessary information for establishing a connection to a database. It is a string value containing details such as server name, database name, authentication credentials, and other relevant parameters. | Dataset.DB.ProviderName.ConnectionString |
This section describes only some commonly used properties, for the full list properties and methods, go to the Namespaces Reference.
In this section: