First field of the first record.
| QueryStatement | Statement to run as a query. |
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.
% 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