Result of the query.
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.
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.
% 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