From: MaggotChild <hsomob1999@...>
Date: 2010-06-27T10:30:09+09:00
Subject: Odd Issue With DBD::SQLite3 - Inserts Don't Work

On Windows XP using Ruby 1.9.1 the following fails to insert:

db = DBI.connect("dbi:SQLite3:#{ARGV.shift}")
s = db.prepare "insert into hits (hit_id, status_id, local_path,
remote_path, created_at) values (?, ?, ?, ?,?)"
s.execute "A123", 1, "A", "B", "2009-01-01"
s.finish
s = db.prepare "select * from hits"
s.execute
while row = s.fetch do
  p row
end
s.finish
db.disconnect

using the SQLite3 library directly works? What could be causing this?
I'm using:

dbi 0.4.5
dbd-sqlite3 1.2.5
sqlite3-ruby 1.3.0

Thanks