[Chicken-users] Re: sqlite3 issues

[Alejandro Forero Cuervo]

> the error you posted is apparently thrown by the SQLite3 SQL parser
> due to the fact that DELECT is not a valid SQL command.

You're right, Thomas.  Boy do I feel stupid now! :-(  Of course,
that's invalid SQL right there.  I guess I'm going to have to blame it
on lack of sleep.

Anyway, the typo was in the report I sent, not in the original error.  I have
the following fail:

    $ csi
      ___| |    _)      |               
     |     __ \  |  __| |  /  _ \ __ \  
     |     | | | | (      <   __/ |   | 
    \____|_| |_|_|\___|_|\_\\___|_|  _| 

    Version 2.5 - linux-unix-gnu-x86 - [ dload ptables applyhook ]
    (c)2000-2006 Felix L. Winkelmann
    #;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-other.db"))
    #;3> (sqlite3:for-each-row (constantly #f) db "DELETE FROM links")
    #;4> (sqlite3:for-each-row (constantly #f) db "DELETE FROM links")
    Error: (sqlite3:prepare) unrecognized token: ""
    #<sqlite3:database>
    "DELETE FROM links"

            Call history:

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

This sentence is valid SQL and sqlite3 can successfully execute it:

    $ sqlite3 deps.db
    SQLite version 3.2.1
    Enter ".help" for instructions
    sqlite> DELETE FROM links;
    sqlite>

Thank you for your help, Thomas.

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