# Odd Issue With DBD::SQLite3 - Inserts Don't Work

**URL:** <https://www.ruby-forum.com/t/odd-issue-with-dbd-sqlite3-inserts-dont-work/190761>\
**Category:** Ruby\
**Created:** [June 27, 2010, 3:31am UTC](https://www.ruby-forum.com/t/odd-issue-with-dbd-sqlite3-inserts-dont-work/190761 "2010-06-27T03:31:40Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![MaggotChild](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/7ea924/32.png) [@MaggotChild](https://www.ruby-forum.com/u/MaggotChild)\
**Post date:** [June 27, 2010, 3:31am UTC](https://www.ruby-forum.com/t/odd-issue-with-dbd-sqlite3-inserts-dont-work/190761/1 "2010-06-27T03:31:40Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![MaggotChild](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/7ea924/32.png) [@MaggotChild](https://www.ruby-forum.com/u/MaggotChild)\
**Post date:** [June 27, 2010, 3:35am UTC](https://www.ruby-forum.com/t/odd-issue-with-dbd-sqlite3-inserts-dont-work/190761/2 "2010-06-27T03:35:11Z")

</div>

On Jun 26, 6:28 pm, MaggotChild [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) 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…