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

Reply via email to