sqlite query

(sqlite-query db q)

sqlite-query runs a query against a SQlite database.

Parameter	Description
db	Handle to the SQlite database
q	Query string to be run

Example

Example 1: Write two entries to an SQlite database and query its content.

> (define file "test.sqlite")
> (define db (sqlite-open file))
> (sqlite-query db "create table tbl1(one varchar(10), two smallint)")
#f
> (sqlite-query db "insert into tbl1 values('hello!',10)")
()
> (sqlite-query db "insert into tbl1 values('goodbye', 20)")
()
> (display (sqlite-query db "select * from tbl1")) (newline)
((hello! 10) (goodbye 20) (hello! 10) (goodbye 20))> 
> (sqlite-close db)