[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Chicken-users] Re: sqlite3 issues
From: |
Alejandro Forero Cuervo |
Subject: |
[Chicken-users] Re: sqlite3 issues |
Date: |
Wed, 8 Nov 2006 16:49:46 +0000 |
User-agent: |
Mutt/1.5.9i |
> 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/