Re: [sqlite] When I try to .read I get a "can't open" message

[Douglas McCarroll]

Thanks all! Yes, dropping the semicolon fixed it...

On Mon, Mar 31, 2008 at 6:11 PM, Kees Nuyt <[EMAIL PROTECTED]> wrote:

>  On Mon, 31 Mar 2008 17:11:35 -0400, you wrote:
>
> >I'm sure I'm doing something simple and obvious wrong here. I'm a
> complete
> >sqlite n00b.
> >
> >Help?
> >
> >C:\_source>sqlite3 test
> >SQLite version 3.5.7
> >Enter ".help" for instructions
> >sqlite> .read test.sql;
> >can't open "test.sql;"
> >sqlite> .read C:/_source/test.sql;
> >can't open "C:/_source/test.sql;"
>
> Drop the semicolon, .read is not an SQL statement.
> --
>  (  Kees Nuyt
>  )
> c[_]
>  ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] When I try to .read I get a "can't open" message

[Kees Nuyt]

On Mon, 31 Mar 2008 17:11:35 -0400, you wrote:

>I'm sure I'm doing something simple and obvious wrong here. I'm a complete
>sqlite n00b.
>
>Help?
>
>C:\_source>sqlite3 test
>SQLite version 3.5.7
>Enter ".help" for instructions
>sqlite> .read test.sql;
>can't open "test.sql;"
>sqlite> .read C:/_source/test.sql;
>can't open "C:/_source/test.sql;"

Drop the semicolon, .read is not an SQL statement.
-- 
  (  Kees Nuyt
  )
c[_]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] When I try to .read I get a "can't open" message

[Clark Christensen]

It's the trailing semicolon.  The dot commands don't require them, while SQL 
statements do.

- Original Message 
From: Douglas McCarroll <[EMAIL PROTECTED]>
To: "sqlite-users@sqlite.org" 
Sent: Monday, March 31, 2008 2:11:35 PM
Subject: [sqlite] When I try to .read I get a "can't open" message

I'm sure I'm doing something simple and obvious wrong here. I'm a complete
sqlite n00b.

Help?

C:\_source>sqlite3 test
SQLite version 3.5.7
Enter ".help" for instructions
sqlite> .read test.sql;
can't open "test.sql;"
sqlite> .read C:/_source/test.sql;
can't open "C:/_source/test.sql;"
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users



___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] When I try to .read I get a "can't open" message

[Steven Fisher]

On 31-Mar-2008, at 2:11 PM, Douglas McCarroll wrote:
> I'm sure I'm doing something simple and obvious wrong here. I'm a  
> complete
> sqlite n00b.
>
> Help?
>
> C:\_source>sqlite3 test
> SQLite version 3.5.7
> Enter ".help" for instructions
> sqlite> .read test.sql;
> can't open "test.sql;"

You shouldn't be including the semicolon. It's that way for most dot  
commands. (Wish it was ignored if present; I make this mistake a lot  
myself.)
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] When I try to .read I get a "can't open" message

[P Kishor]

On 3/31/08, Douglas McCarroll <[EMAIL PROTECTED]> wrote:
> I'm sure I'm doing something simple and obvious wrong here. I'm a complete
>  sqlite n00b.
>
>  Help?
>
>  C:\_source>sqlite3 test
>  SQLite version 3.5.7
>  Enter ".help" for instructions
>  sqlite> .read test.sql;
>  can't open "test.sql;"
>  sqlite> .read C:/_source/test.sql;
>  can't open "C:/_source/test.sql;"
>  ___

take out the ; at the end of the statement. .read is a sqlite3 shell
command, not a SQL statement. Also, try putting your path in single
quotes (or is double quotes... try both).

sqlite> .read 'test.sql'
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users