[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