John Stanton wrote: > Adding Javascript to Sqlite as a stored procedure language was a fairly > simple operation. Try it if you need stored procedures.
This sounds really interesting. How to you make access to the sqlite3 api in javascript? Would you need to? Seems like you would need to at least provide some interface to the DB functions so you can do things like INSERT, UPDATE, DELETE, SELECT, and step through the results, etc. -Steve > BareFeet wrote: >> Hi John, >> >> >>> I would like to know if SQLite supports stored procedures. >> >> Technically, no it doesn't. >> >> For what purpose do you want to store procedures? >> >> 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. >> >> Tom >> BareFeet >> >> -- >> Comparison of SQLite GUI applications: >> http://www.tandb.com.au/sqlite/compare/ >> >> _______________________________________________ >> sqlite-users mailing list >> sqlite-users@sqlite.org >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users