Use command line sqlite or check for any error after creating table.
Enter SQL statements terminated with a ";"
sqlite> CREATE table stnInfo (id int recNum primary key, call varchar(8), name varchar(80), addr
ess1 varchar(80), accress2 varchar(80), city varchar(80), state varchar(80), state varchar(40),
postalCode varchar(20), country varchar(40), grid varchar(8), cqZone varchar(8), ituZone varchar
(8), latitude varchar(8), longitude varchar(8), licenseClass varchar(12));
SQL error: duplicate column name: state
sqlite>
Bookmarks