On 5/8/2018 4:02 PM, Mike Clark wrote:
Has there been any thought of implementing some kind of stored procedure
feature for SQLite?
Or does this feature exist in some other form, with another name?
Triggers are kind of like stored procedures. You can create a dedicated view and put
INSTEAD OF trigger on it. To "call" the trigger, insert a row into the view -
the trigger could use column values, available via new.columnName, as its parameters.
sqlite-users mailing list