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

от Rijkstra Май 29, 2015 · permalink

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.