subject:"\[sqlite\] Virtual table row deletition on trigger"

Re: [sqlite] Virtual table row deletition on trigger

2017-12-09 Thread Tibor Balog

Hi, I have realized that this quetion went awry so I give it a second run. My scenario: Enviroment: DotNet, no 3d party library just pinvoke. SQLite: Sqlite library version:3022000 -COMPILER=msvc-1911 -ENABLE_FTS5 -LIKE_DOESNT_MATCH_BLOBS -MAX_EXPR_DEPTH=0 -OMIT_DECLTYPE -OMIT_DEPRECATED

Re: [sqlite] Virtual table row deletition on trigger

2017-12-08 Thread Tibor Balog

he transaction frame it is working fine. -Ursprüngliche Nachricht- From: Tibor Balog Sent: Friday, December 8, 2017 7:11 PM To: SQLite Subject: [sqlite] Virtual table row deletition on trigger Hello, I run into a little anoyance regarding virtual table. I have a contentless table: CREATE VIRTU

[sqlite] Virtual table row deletition on trigger

2017-12-08 Thread Tibor Balog

Hello, I run into a little anoyance regarding virtual table. I have a contentless table: CREATE VIRTUAL TABLE "OCR" using fts5 (content='',FullText) bind with a trigger for row deletition: CREATE TRIGGER "ART_AD" AFTER DELETE ON "ART" BEGIN INSERT INTO "OCR" ("OCR",rowid)