chickadee » sqlite3 » bind!

bind! STATEMENT I OBJECTprocedure

Can be applied to any statement to bind its free parameter number I(counting from 0) to the given value. Scheme types of the value map to SQLite types as follows:

Scheme typeSQLite type
boolean?integer: #t = 1, #f = 0
fixnum?integer
real?float
string?text
blob?blob
sql-null?null

Unless there is internal trouble in SQLite, this method should always succeeds and never throw an exception. For invalid parameter indices the method just silently does nothing.