Strangely, I can't get the 'Periodic table' from the NewLisp introduction to work either.
thanks again.
- Welcome to newLISP Fan Club.
This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.
#91
So, what can you actually DO with newLISP? / Re: sqlite3 problem "no such table"
February 19, 2010, 12:49:03 PMStrangely, I can't get the 'Periodic table' from the NewLisp introduction to work either.
thanks again.
#92
So, what can you actually DO with newLISP? / sqlite3 problem "no such table"
February 19, 2010, 05:08:57 AMI 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