Can you send examples? Thanks
Woody from his pda -----Original Message----- From: John Stanton <[EMAIL PROTECTED]> Sent: Tuesday, July 29, 2008 11:39 AM To: General Discussion of SQLite Database <sqlite-users@sqlite.org> Subject: Re: [sqlite] Does sqlite support stored procedure? Adding Javascript to Sqlite as a stored procedure language was a fairly simple operation. Try it if you need stored procedures. 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