NAME
QQ — Run the query with configured database and return result.
SYNOPSIS
QQ QueryStatement
DESCRIPTION
Return Value
Result of the query.
Arguments
QueryStatementStatement to run as a query.
More Info
To use this command, you must configure Gen for database use. You can read about that on the page: About Configuration for Database Use.

This command currently only supports SQLite database connections.

This is equivalent to dbcmd eval sql but is shorter to type and uses the previously configured connection.


For information regarding exceptions / errors, see here.
EXAMPLES
% RunSqlCreate my_table {id {integer primary key} desc text notes text}
% QQ [SqlInsertStatement my_table {desc 'one' notes 'uno'}]
% QQ "SELECT desc, notes FROM my_table WHERE id = 1"
one uno
SEE ALSO
Q1
KEYWORDS
sql