From: basi <basi_lio@...>
Date: 2005-10-24T03:32:01+09:00
Subject: Re: Using SQLite

Hello,

In the following, as soon as I hit Return (on the 003 line), the fxri
screen disappears. "Products" is a table in the database. Did I enter
the command properly? When I enter the select command in SQLiteSpy, it
works. Thanks.
gk

irb(main):001:0> require 'sqlite3'
=> false
irb(main):002:0> db =
SQLite3::Database.new("c:\work\depot\db\depot_development.db3")
=> #<SQLite3::Database:0x4037078
@driver=#<SQLite3::Driver::Native::Driver:0x4025f78 @callback_data={}>,
@statement_factory=SQLite3::Statement, @type_translation=false,
@handle=#<SWIG::TYPE_p_sqlite3:0x4025ed0>, @results_as_hash=false,
@closed=false, @translator=nil>
irb(main):003:0> count = db.get_first_value( "select count(*) from
products")