datafile = 'XZ704.DB'
datadir = '/full_path_to/SQLITE_FILES/'
db = datadir+datafile
conn = sqlite3.connect(db)
cur = conn.cursor()
cur.execute("SELECT * FROM Airports LIMIT 1")
OperationalError: no such table: Airports
That works fine in a terminal but for some reason python 2.7 no like.
I have tried full path, relative path and same directory. No joy.
Google shows lot's of same problem but none of the suggested answers works on my linux (Ubuntu 15.04 MATE Desktop Environment 1.8.2) installation.
A previous poster here saw the light refering to "read the "Multidb and Database Router" section. Router is the answer" but I can't find it here (possibly some Django man pages?)