Re: [sqlite] Syntax Error Loading Values Into Table -- SOLVED!

2006-09-20 Thread Rich Shepard
On Wed, 20 Sep 2006, Rich Shepard wrote: What did I miss here, please? Mea culpa! I specified only one column, not both. Rich -- Richard B. Shepard, Ph.D. |The Environmental Permitting Applied Ecosystem Services, Inc.(TM)|Accelerator

[sqlite] Syntax Error Loading Values Into Table

2006-09-20 Thread Rich Shepard
I have a table created as: CREATE TABLE hedge (hedge_id integer primary key, hedge_name text); Within the sqlite3 shell I try to load values from the file, 'load-hedges.sql,' and the file has 16 lines of the form: insert into hedge (hedge_name) values ('around'); SQLite complains,