Hey GSN --
I'm not sure why it's throwing the error. As a safety measure, it's
probably a good idea to put 'drop table if exists activejobs' that way if
the tables don't exist there won't be an error.
-Ben
On Fri, Sep 5, 2008 at 3:35 PM, GSN <[EMAIL PROTECTED]> wrote:
>
> I have a PHP page which does little else but drop tables to clear out
> tables from the DB. This page worked prior to 0.4 being released.
> All other pages and DB access works fine.
>
> The error is: Could not delete tables: SQLite prepare() failed. ERROR:
> SQL logic error or missing database DETAILS: no such table: activejobs
> EXPRESSION: drop table activejobs;
>
> Has anyone else experienced the same issue?
>
> Thanks - GSN
>
>
> The code is simple - I have not included the gears includes nor the
> HTML.
>
> db = google.gears.factory.create('beta.database');
> try {
> db.open('damcoDB');
>
> } catch (ex) {
> alert('Could not open damcoDB: ' + ex.message);
> }
>
> try {
>
> db.execute('drop table activejobs;');
> db.execute('drop table currentsession;');
>
> // I removed additional table entries here for simplicity
>
> db.execute('drop table out_manifest;');
> db.execute('drop table plates;');
>
> alert("Delete Complete");
>
> } catch (ex) {
> alert('Could not delete tables: ' + ex.message);
> }
>
> try {
> db.close();
> } catch (ex) {
> alert('Could not close damcoDB: ' + ex.message);
> }
>
