On Thu, 21 Sep 2006, Igor Tandetnik wrote:
You list two column names, but only provide one value. Make itinsert 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. Also, if I open the database within sqlite3, and the table is already created, I can use the sqlite3 shell to insert a single record using the same syntax that fails when there are multiple values to be inserted. This all started when I tried to run the file -- with only the insert statements because the table already existed -- within the sqlite shell. I used '.import load_hedges.sql hedge' and kept getting the same error message. I would really like to understand why. Thanks, Igor, Rich -- Richard B. Shepard, Ph.D. | The Environmental Permitting Applied Ecosystem Services, Inc.(TM) | Accelerator <http://www.appl-ecosys.com> Voice: 503-667-4517 Fax: 503-667-8863 ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
