NAME
Q1 — Execute a query and return the first field of first record.
SYNOPSIS
Q1 QueryStatement
DESCRIPTION
Return Value
First field of the first record.
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.

Note also there is the sqlite command dbcmd onecolumn sql. The difference is that this command has a short name and will use your 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'}]
% Q1 "SELECT desc FROM my_table WHERE id = 1"
one
SEE ALSO
QQ
KEYWORDS
sql