Views

Views contain data extracts from tables or other views. Deleting a view does not result in data loss.

Source file : CreateViews.sql

Hot view

After modification of the data displayed by a view, the data in the underlying tables can be updated via INSTEAD OF triggers.

-- In CreateTables.sql
CREATE TABLE myTable (
    ID INTEGER PRIMARY KEY AUTOINCREMENT,
    Field1 TEXT;

-- In CreateViews.sql
CREATE VIEW myTable__Edit AS SELECT ID,Field1 FROM myTable;

-- In CreateTriggers.sql
CREATE TRIGGER myTable__Edit_INSERT INSTEAD OF INSERT ON myTable__Edit
BEGIN
    INSERT INTO myTable (Field1) VALUES (NEW.Field1);
END;;

CREATE TRIGGER myTable__Edit_UPDATE INSTEAD OF UPDATE ON myTable__Edit
BEGIN
    UPDATE myTable SET
        Field1=NEW.Field1
     WHERE myTable.ID=OLD.ID;
END;;

CREATE TRIGGER myTable__Edit_DELETE INSTEAD OF DELETE ON myTable__Edit
BEGIN
    DELETE FROM myTable WHERE myTable.ID=OLD.ID;
END;;

The edit buttons on a view tab are automatically activated if these triggers are present.