- first-result STATEMENT #!rest PARAMETERSprocedure
- first-result DATABASE SQL #!rest PARAMETERSprocedure
(Compiles the given SQL), resets the statement, binds the statement's free parameters and single-steps the statement once returning the value of the first column in the first result row. Resets the statement again just before returning.
If the given statement does not yield any results, an (exn sqlite3) is thrown with the status-property set to done.