Re: [sqlite] Re: Re: Cannot Find Syntax Error -- SOLVED!

2006-09-21 Thread Rich Shepard 

On Thu, 21 Sep 2006, Clark Christensen wrote:


From the command line, you can use
sqlite3 foo.db ".read load_hedges.sql"


Clark,

  Thank you.

Rich

--
Richard B. Shepard, Ph.D.   |The Environmental Permitting
Applied Ecosystem Services, Inc.(TM)|Accelerator
 Voice: 503-667-4517  Fax: 503-667-8863

-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] Re: Re: Cannot Find Syntax Error -- SOLVED!

2006-09-21 Thread Clark Christensen 
>From the command line, you can use

sqlite3 foo.db ".read load_hedges.sql"

 -Clark

- Original Message 
From: Rich Shepard <[EMAIL PROTECTED]>
To: SQLite 
Sent: Thursday, September 21, 2006 9:25:02 AM
Subject: Re: [sqlite] Re: Re: Cannot Find Syntax Error -- SOLVED!

On Thu, 21 Sep 2006, Igor Tandetnik wrote:

> Check that this existing table does indeed have the columns you think it has. 
> Try running this from the shell:

Igor,

   I found the problem ... at least, from within the sqlite3 shell. I was
using the incorrect tool. :-(

   Since the file contained valid SQL statements, I need to use
sqlite> .read load_hedges.sql

rather than .import 

   Makes all the difference!

   Now, why it's not working from the command line I don't know. But, within
the sqlite shell, I need the .read command.

Thanks,

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]
-





-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] Re: Re: Cannot Find Syntax Error -- SOLVED!

2006-09-21 Thread Rich Shepard 

On Thu, 21 Sep 2006, Igor Tandetnik wrote:

Check that this existing table does indeed have the columns you think it has. 
Try running this from the shell:


Igor,

  I found the problem ... at least, from within the sqlite3 shell. I was
using the incorrect tool. :-(

  Since the file contained valid SQL statements, I need to use
sqlite> .read load_hedges.sql

rather than .import 

  Makes all the difference!

  Now, why it's not working from the command line I don't know. But, within
the sqlite shell, I need the .read command.

Thanks,

Rich

--
Richard B. Shepard, Ph.D.   |The Environmental Permitting
Applied Ecosystem Services, Inc.(TM)|Accelerator
 Voice: 503-667-4517  Fax: 503-667-8863

-
To unsubscribe, send email to [EMAIL PROTECTED]
-