From: Thufir <hawat.thufir@...>
Date: 2007-11-19T14:49:41+09:00
Subject: create, read, update an sqlite database

This is all from <http://sqlite-ruby.rubyforge.org/sqlite3/faq.html>.  
How do interpret the following error pls:

thufir@arrakis ~/rubyCode/sqlite $ 
thufir@arrakis ~/rubyCode/sqlite $ ruby seven.rb 
/usr/lib/ruby/gems/1.8/gems/sqlite3-ruby-1.1.0/lib/sqlite3/
errors.rb:94:in 
`check': no such table: test (SQLite3::SQLException)
        from 
/usr/lib/ruby/gems/1.8/gems/sqlite3-ruby-1.1.0/lib/sqlite3/
statement.rb:70:in 
`initialize'
        from 
/usr/lib/ruby/gems/1.8/gems/sqlite3-ruby-1.1.0/lib/sqlite3/
database.rb:183:in 
`new'
        from 
/usr/lib/ruby/gems/1.8/gems/sqlite3-ruby-1.1.0/lib/sqlite3/
database.rb:183:in 
`prepare'
        from 
/usr/lib/ruby/gems/1.8/gems/sqlite3-ruby-1.1.0/lib/sqlite3/
database.rb:210:in 
`execute'
        from seven.rb:4
thufir@arrakis ~/rubyCode/sqlite $ 
thufir@arrakis ~/rubyCode/sqlite $ 
thufir@arrakis ~/rubyCode/sqlite $ gem search sqlite --both

*** LOCAL GEMS ***

sqlite-ruby (2.2.3)
    SQLite/Ruby is a module to allow Ruby scripts to interface with a
    SQLite database.

sqlite3-ruby (1.1.0)
    SQLite3/Ruby is a module to allow Ruby scripts to interface with a
    SQLite3 database.

*** REMOTE GEMS ***
Bulk updating Gem source index for: http://gems.rubyforge.org
thufir@arrakis ~/rubyCode/sqlite $ 
thufir@arrakis ~/rubyCode/sqlite $ 
thufir@arrakis ~/rubyCode/sqlite $ cat seven.rb 
  require 'sqlite3'

  db = SQLite3::Database.new( "test.db" )
  rows = db.execute( "select * from test" )
thufir@arrakis ~/rubyCode/sqlite $ 
thufir@arrakis ~/rubyCode/sqlite $ 
thufir@arrakis ~/rubyCode/sqlite $ cat /etc/gentoo-release 
Gentoo Base System release 1.12.9
thufir@arrakis ~/rubyCode/sqlite $ 
thufir@arrakis ~/rubyCode/sqlite $ date
Sun Nov 18 21:39:49 PST 2007
thufir@arrakis ~/rubyCode/sqlite $ 
thufir@arrakis ~/rubyCode/sqlite $ 



Wasn't it supposed to create test.db in line three?




thanks,

Thufir