SQLite Triggers

[Dermot]

Has any oned used triggers with SQLite? I have been trying to get it to work but no luck.

This is what I have but the trigger never gets created.

SQLite.Query(db, "CREATE TRIGGER InvoiceItemsDelete(AFTER DELETE ON Invoices BEGIN DELETE FROM InvoiceDetails WHERE InvID = Old.InvoiceID END)")

Dermot

[Dermot]

Never mind, got it working. The following is what worked.

SQLite.Query(db, "CREATE TRIGGER InvoiceItemsDelete AFTER DELETE ON Invoices BEGIN DELETE FROM InvoiceDetails WHERE InvID = Old.InvoiceID; END")

Dermot