On Thu, 26 Feb 2009 17:33:25 -0500, Bryan Lemster <bryan.lems...@gmail.com> wrote:
>Hello, > I have a question on sqlite - Is there a good way to launch an >executable when a table is updated? Thanks. Not out-of-the-box, but you could write a function in a loadable extension which forks a process and have that function called in an ON UPDATE trigger. http://www.sqlite.org/cvstrac/wiki?p=LoadableExtensions http://www.sqlite.org/c3ref/create_function.html http://www.sqlite.org/lang_createtrigger.html Alternatively, you could change the SQLite source for your purpose. I don't advise this, it's hard to maintain. A loadable extension is the "proper mechanism". >-Bryan -- ( Kees Nuyt ) c[_] _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users