sqlite open

(sqlite-open dbname)

sqlite-open makes a connection to an SQlite database file.

Parameter	Description
dbname	Filename of the SQlite database

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)