| 1 | The result was greater than 0. |
| 0 | Result was not greater than 0. |
| TableName | Name of table to search. |
| WhereDict | List with column names and column values. |
| Name of table to check for record. |
Note that for the dicts, you (currently) must put quotes around any values that will go into text columns or receive an error. We may add support in a future release for automatically detecting the column type and quoting values as necessary.
Check About Configuration for Database Use for info about how to set up Gen for using database-related commands.
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'}]
% SqlRecordExists my_table {desc 'one'}
1