Re: [sqlite] Error: no such table on .import

[Griggs, Donald]

sqlite> .import C:\HEAD.txt head;
Error: no such table: head;
Any idea why I'm getting "no such table"?

Hi Phil,

The "dot" commands -- such as .import -- don't require a semicolon terminator, 
and the utility is interpreting your trailing semicolon as part of the table 
name.

You may also want to surround 'c:\head.txt' with single quotes, but I think if 
you omit the semicolon you'd finally get ahead with your work.

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

Re: [sqlite] Error: no such table on .import

[Phil Hibbs]

> because of the semicolon following the table name in your .import -
> command. Remove it.

Yes, I was just about to reply saying I'd spotted that. Funny how
after half an hour of scratching your head, you post to a mailing list
and then spot it immediately. Thanks and apologies.

Phil Hibbs.
-- 
Don't you just hate self-referential sigs?
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Error: no such table on .import

[Martin Engelschalk]

Hi,

because of the semicolon following the table name in your .import - 
command. Remove it.

Martin

Phil Hibbs wrote:
> I'm doing this in SQLite:
>
> sqlite> .separator tabs
> sqlite> create table head
>...> ( id varchar(10)
>...> , tplnr varchar(20)
>...> , plnal varchar(2)
>...> , ktext varchar(40)
>...> , arbpl varchar(10)
>...> , werks varchar(4)
>...> , verwe varchar(1)
>...> , vagrp varchar(3)
>...> , statu varchar(1)
>...> , sttag varchar(8)
>...> , strat varchar(6)
>...> , batchno varchar(3)
>...> );
> sqlite> .import C:\HEAD.txt head;
> Error: no such table: head;
> sqlite> .schema
> CREATE TABLE head
> ( id varchar(10)
> , tplnr varchar(20)
> , plnal varchar(2)
> , ktext varchar(40)
> , arbpl varchar(10)
> , werks varchar(4)
> , verwe varchar(1)
> , vagrp varchar(3)
> , statu varchar(1)
> , sttag varchar(8)
> , strat varchar(6)
> , batchno varchar(3)
> );
>
> Any idea why I'm getting "no such table"?
>
> Phil Hibbs.
>   
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Error: no such table on .import

[Phil Hibbs]

I'm doing this in SQLite:

sqlite> .separator tabs
sqlite> create table head
   ...> ( id varchar(10)
   ...> , tplnr varchar(20)
   ...> , plnal varchar(2)
   ...> , ktext varchar(40)
   ...> , arbpl varchar(10)
   ...> , werks varchar(4)
   ...> , verwe varchar(1)
   ...> , vagrp varchar(3)
   ...> , statu varchar(1)
   ...> , sttag varchar(8)
   ...> , strat varchar(6)
   ...> , batchno varchar(3)
   ...> );
sqlite> .import C:\HEAD.txt head;
Error: no such table: head;
sqlite> .schema
CREATE TABLE head
( id varchar(10)
, tplnr varchar(20)
, plnal varchar(2)
, ktext varchar(40)
, arbpl varchar(10)
, werks varchar(4)
, verwe varchar(1)
, vagrp varchar(3)
, statu varchar(1)
, sttag varchar(8)
, strat varchar(6)
, batchno varchar(3)
);

Any idea why I'm getting "no such table"?

Phil Hibbs.
-- 
Don't you just hate self-referential sigs?
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users