Rijkstra

내 정보

개발자 정보
이름 Rijkstra
가입한 날짜 1월 6, 2015
개발한 부가 기능 수 부가 기능 0개
이 개발자의 부가 기능의 평균 별점 아직 별점 없음

내 검토

SQLite Manager

5점중 5점 받음

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.

전에 이 사용자는 이 부가 기능에 1개 검토를 했습니다.

SQLite Manager

5점중 4점 받음

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.