From: Eito Katagiri <eitoball@...>
Date: 2010-09-12T00:48:54+09:00
Subject: Re: sqlite3-ruby failing on 1.9.2 ?

Hi,

On Sat, Sep 11, 2010 at 10:43 PM, Rahul Kumar <sentinel1879@gmail.com> wrote:
> If I issue as simple statement such as:
>
>   db.execute(" insert into basic (  id, desc ) values (?,?)",10, desc )
>
> The first column gets a nil, which obviously fails if that col has a
> constraint.

Try the statement below instead

  db.execute(" insert into basic (  id, desc ) values (?,?)", [10, desc ])

> (my 1.9.1 version is an earlier on 1.2.5)

Some APIs have been changed since version 1.3.0.
According to API_CHANGES.rdoc,

  SQLite3::Database#execute only accepts an array for bind parameters.