Rich Shepard <[EMAIL PROTECTED]> wrote:
On Thu, 21 Sep 2006, Igor Tandetnik wrote:
You list two column names, but only provide one value. Make it
insert into hedge (hedge_name) values ('around');
That's what I did originally, but got the same error.
insert into hedge (hedge_id, hedge_name) values (null, 'around');
I did not try this variety because sqlite is supposed to
automatically increment the hedge_id if it's defined as 'integer
primary key.' Why it is not automatically filling in that value is
what I'm trying to understand.
It does for me. Both variations work, I've tried them.
This all started when I tried to run the file -- with only the
insert statements because the table already existed
Check that this existing table does indeed have the columns you think it
has. Try running this from the shell:
select sql from sqlite_master where tbl_name='hedge';
Verify that the CREATE TABLE statement looks the way you expect.
Igor Tandetnik
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
