chickadee » sqlite3 » first-result

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.