Rijkstra

O mně

Informace o vývojáři
Jméno Rijkstra
Zaregistrován(a) od Led. 6, 2015
Počet vyvíjených doplňků 0 doplňků
Průměrné hodnocení doplňků vývojáře Nehodnoceno

Mé recenze

SQLite Manager

Ohodnoceno 5 z 5 hvězdiček

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.

Tento uživatel má jednu dřívější recenzi tohoto doplňku.

SQLite Manager

Ohodnoceno 4 z 5 hvězdiček

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.