sqlite3 bug?

dads wayne.dads.bell at gmail.com
Wed Feb 10 19:16:23 EST 2010


When the method below is run it raises 'sqlite3.OperationalError: no
such table: dave'.
the arguments are ds = a datestamp and w = a string of digits. The
path of the db is
C:\sv_zip_test\2006\2006.db and the table is definitely named dave.
I've run the sql
in sql manager and it works. Is this a bug?


def findArchive(self, ds, w):

        year = ds.GetYear()
        if year < 2005:
            wx.MessageBox('Year out of Archive, check the date!')
            return

        year = str(year)
        archive = 'C:/sv_zip_test'
        dbfp = os.path.abspath(os.path.join(archive, year, year +
'.db'))
        if os.path.exists(dbfp):
            con = sqlite3.connect('dbfp')
            cur = con.cursor()
            #cur.execute("SELECT * FROM dave WHERE webno = ?", [w])
            cur.execute("SELECT * FROM dave")
            for r in cur:
                self.fil.AppendText(r[2] + '\n')
        else:
            wx.MessageBox('no db, %s' % dbfp)



More information about the Python-list mailing list