Back to Aurora Vision Studio website
You are here: Start » Filter Reference » System » SQLite » SQLite_Query
Basic| Module: | FoundationLite |
|---|
Queries the SQLite database.
| Name | Type | Description | |
|---|---|---|---|
 |
inFile | File | Path to an SQLite database file. |
|
inQuery | String | SQL Query. |
|
inIncludeColumnTitles | Bool | Whether or not to include column names in the output data. |
 |
outData | 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
- SQLite_Read – Reads a value from the SQLite database.
- SQLite_Write – Writes a value to the SQLite database.
