I use triggers, particularly INSTEAD OF INSERT triggers on VIEWs. The values of the columns of the rows to be "inserted" are the "stored procedure's" arguments. I use WHERE clauses judiciously to make up for the lack of IFs. It works well enough.
I've used this in combination with recursive triggers to implement recursive CTEs before SQLite3 added support for them. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users