Back to Aurora Vision Studio website

You are here: Start » Filter Reference » System » SQLite » SQLite_Read

SQLite_Read

Basic

Module: FoundationLite

Reads a value from the SQLite database.

Name Type Description
Input value inFile File Path to an SQLite database file.
Input value inTableName String Name of the table to access.
Input value inColumnName String Which column will be checked.
Input value inQueriedColumn String Column name to compare.
Input value inQueryValue String Value to compare.
Input value inIncludeColumnTitles Bool Whether or not to include column names in the output data.
Output value outReadData StringArrayArray Data read as strings.

Remarks

SQL database driver software

This filter is intended to cooperate with SQLite database files.

Database file

inFile field should be a path to a database file. The file will be created if it doesn't exist.

Errors

This filter can throw an exception to report error. Read how to deal with errors in Error Handling.

List of possible exceptions:

Error type Description
RuntimeError Not implemented

Complexity Level

This filter is available on Basic Complexity Level.

Disabled in Lite Edition

This filter is disabled in Lite Edition. It is available only in full, Aurora Vision Studio Professional version.

See Also