Hello SQLite Users
Is there a possibility to define variables within trigger definitions? I would like to to something like this (simplified example):
CREATE TRIGGER Side_Insert AFTER INSERT ON Side BEGIN SET LOWDATE = SELECT MIN(Startdate) FROM Basis; .... INSERT INTO BASIS (Name,Startdate) VALUES ("Trigger", LOWDATE); END;
I know, there is the possibility to do the same with SUBSELECTS,
but I'm looking for something easier/faster/more elegant than doing the same subselect several times.
(as my real example is more complicated)
Even if there is no possibility right know, I would probably suggest this as a feature for the future.
Thanks a lot!
Philipp