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
> 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.
--
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)
>
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)
4 matches
Mail list logo