[Chicken-users] sqlite3 issues

[Alejandro Forero Cuervo]

I'm trying to get svnwiki to use sqlite3 instead of sqlite.  However,
I've stumbled into a problem.

I created a DB.  I can use my sqlite3 binary to execute queries
against it.

However, I'm failing to get the sqlite3:for-each-row function from
Chicken's sqlite3 egg to execute for some queries:

    #;1> (use sqlite3)
    ; loading /opt/chicken-2.5/lib/chicken/1/sqlite3.so ...
    ; loading /opt/chicken-2.5/lib/chicken/1/tinyclos-base.so ...
    ; loading /opt/chicken-2.5/lib/chicken/1/synch-support.so ...
    #;2> (define db (sqlite3:open "deps.db"))
    #;3> db
    #<sqlite3:database>
    #;4> (sqlite3:for-each-row (constantly #f) db "SELECT * FROM links;")
    #;5> (sqlite3:for-each-row (constantly #f) db "DELECT FROM links;")
    Error: (sqlite3:prepare) unrecognized token: ""
    #<sqlite3:database>
    "DELECT FROM links;"

            Call history:

            <eval>          (sqlite3:for-each-row (constantly #f) db "DELECT 
FROM links;")
            <eval>          (constantly #f) <--
    #;5>

Am I misunderstanding something or is this a bug in the sqlite3 egg?

Thank you for your work in making wrappers around sqlite3, Thomas!  I
certainly benefit from them.  :-)

Alejo.
http://azul.freaks-unidos.net/