Re: [sqlite] Virtual table row deletition on trigger

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

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

Re: [sqlite] DateTime to bigint

ue193 twitter: @sandersonforens Tel +44 (0)1326 572786 http://sandersonforensics.com/forum/content.php?195-SQLite-Forensic- Toolkit -Forensic Toolkit for SQLite email from a work address for a fully functional demo licence On 8 December 2017 at 16:53, Tibor Balog <tibor.ba...@gmx.ch> wrote: Hi t

[sqlite] Virtual table row deletition on trigger

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)

Re: [sqlite] DateTime to bigint

-SQLite-Forensic-Toolkit -Forensic Toolkit for SQLite email from a work address for a fully functional demo licence On 8 December 2017 at 16:53, Tibor Balog <tibor.ba...@gmx.ch> wrote: Hi there, I am very new to SQLite but like it sofar. Run into something couldn’t find an answer may someone c

[sqlite] DateTime to bigint

Hi there, I am very new to SQLite but like it sofar. Run into something couldn’t find an answer may someone can put me in the right direction.. Have an application uses SQLite table with a column “Datum” defined as bigint. I have an identical table with column “Datum” as DateTime “-mm-dd”