Рейтинг 5 из 5 звёзд

от Rijkstra Июнь 3, 2015 ·

Not a review, but where else can I ask users if they experienced a loss of views and triggers with the Firefox v38.0.5 upgrade? I can understand it if a restructuring occurred with the upgrade. I advise keeping your SQL statements in a separate file just in case you lose them like I did. This is most likely not a bug in the software, but a copying by the upgrade to a new database structure. leaving the frills behind.

Рейтинг 4 из 5 звёзд

от Rijkstra Май 29, 2015 ·

This query executes without errors:

DELETE FROM moz_cookies WHERE baseDomain="newspaper.com"

But when I try to create a view it fails and I can't find a way to save it:

SQLiteManager: CREATE VIEW "main"."DELnews" AS DELETE FROM moz_cookies WHERE baseDomain="newspaper.com" [ near "DELETE": syntax error ]
Exception Name: NS_ERROR_FAILURE
Exception Message: Component returned failure code: 0x80004005 (NS_ERROR_FAILURE) [mozIStorageConnection.createStatement]

I know it shouldn't be a view, but I'm not so sure about a trigger.

I am now. I created a trigger that blocks the cookies. I hope it keeps working the way I expect.