From: MaggotChild on
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



From: MaggotChild on
On Jun 26, 6:28 pm, MaggotChild <hsomob1...(a)yahoo.com> wrote:
> On Windows XP using Ruby 1.9.1 the following fails to insert:
> s = db.prepare "select * from hits"
> s.execute

This works if I insert rows through the sqlite3 client. But, no
inserts...