Text only | Text with Images

newLISP Fan Club

Forum => So, what can you actually DO with newLISP? => Topic started by: jazper on February 19, 2010, 05:08:57 AM

Title: sqlite3 problem "no such table"
Post by: jazper on February 19, 2010, 05:08:57 AM
Hi

I am learning NewLisp:  having imported data (csv) into Sqlite3, I can work fine within the Firefox and Sqlite3Explorer tools.  However from within Newlisp IDE, the error reported is "no such table: MonFriDown".  As I say, the table is there, and usable:  in NewLisp, database opens ok. Code follows:
Code Select

(load (append (env "NEWLISPDIR") "\modules\sqlite3.lsp"))
(if (sql3:open "SimonsTownLine.sqlite3")
(println "database opened/created")
(println "problem:  " (sql3:error)))

(define (query sql-text)
(set 'sqlarray (sql3:sql sql-text)) ; results of query
(if sqlarray
(map println sqlarray)
(println (sql3:error) " query problem ")))

(query "select * from MonFriDown")

 (sql3:error)            
 (sql3:close)  


Does anyone have similar problems with SQLite3, or is there something wrong with my code?

regards
Title: Re: sqlite3 problem "no such table"
Post by: Lutz on February 19, 2010, 09:57:08 AM
Your code looks for  "SimonsTownLine.sqlite3" in the current directory, because it can't find an existing one there, it will create a new, empty one, which doesn't have the table.



You have to give the full path-file-name to your database, so it can find it.



PS: Use
Code Select
(env "NEWLISPDIR") "/modules/sqlite3.lsp")

the forward slashes will work on Unix/Linux/OS X and Win32.



Or simply use:


Code Select
(module "sqlite3.lsp")
Title: Re: sqlite3 problem "no such table"
Post by: jazper on February 19, 2010, 12:49:03 PM
Thanks very much.  I had started with the full path, and had the same problem, that's why I changed it.  But I will try again.



Strangely, I can't get the 'Periodic table' from the NewLisp introduction to work either.



thanks again.
Title: Re: sqlite3 problem "no such table"
Post by: itistoday on February 19, 2010, 06:20:23 PM
BTW, if you're interested in another sqlite3 module, you can take a look at Dragonfly's (//http). It uses a generic interface and ObjNL so that in the future you can easily change databases if needed.



If you check out the mercurial repository (//http) for Dragonfly, there's some neat stuff in there that I've added recently for databases (with sqlite3 being the only one supported currently), including a basic ORM layer and some convenient functions (take a look in the dragonfly-framework/plugins-inactive/db folder). All of this isn't documented yet but it will be released soon with proper documentation.
Text only | Text with Images