Hi BareFeet, >> I would like to know if SQLite supports stored procedures.
>Technically, no it doesn't. >For what purpose do you want to store procedures? We have an application (open source Jaxer) that provides a support layer for the server-side DB, so users can access it in their javascript. If SQLite supports store procedure, then we would like to expose it to the users. >You can store some procedures in triggers, if you want to have SQLite >trigger a task when some data is changed. >You can simply create a "Procedures" table like this: >create table "Procedures" (Name, SQL); >and populate it with SQL procedures. You can call those procedures >later from within your program and sqlite3 command line and execute >them. Thanks for the extra info. John _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
