Re: [sqlite] Does sqlite support stored procedure?

2008-07-29 Thread John Zhang
Hi everyone, Now the discussion has deviated from my original question. But the topic is interesting. We also access SQLite from javascript (through MOZILLA's firefox codebase). Mozilla has a set of XPCOM components that allow easy Javscript access to SQLite (firefox uses SQLite for i

Re: [sqlite] Does sqlite support stored procedure?

2008-07-25 Thread John Zhang
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 javascrip

Re: [sqlite] Does sqlite support stored procedure?

2008-07-25 Thread John Zhang
n of user functions in the calling language, which can then be invoked much like a stored procedure. See also: http://www.sqlite.org/omitted.html http://www.sqlite.org/lang_createtrigger.html -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of John Zhang This

[sqlite] Does sqlite support stored procedure?

2008-07-24 Thread John Zhang
I would like to know if SQLite supports stored procedures. This should be a simple question, but I did not find a clear answer on the SQLite website. Thanks, John ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/m