Triggers won't help, either, because triggers run in the sqlite3 handle which, um, triggers. So if app A makes a change, the trigger runs in app A, but not in app B.
You could have a custom function which the trigger invokes to send an IPC over to app B. -scott On 10/12/07, Vladimir Stokic <[EMAIL PROTECTED]> wrote: > > Hi there, > > I would like to know if there is any way to access some external application > from within an SQLite trigger. > > I have an application A that updates some rows in my SQLite database. What I > want is to be able to detect that the change has occured from the > application B, without having to use the polling mechanism (i.e. to > periodically poll the database and check if the change has occured). > Basically, I need an alarm mechanism that will notify the application B that > the change has occured on the particular table in the database. > > I have read the documentation on http://www.sqlite.org/capi3ref.html and I > have not found anything that would be useful in this particular situation. > At first I thought it could be done using sqlite3_update_hook, but then I > learned that sqlite3_update_hook does not work that way. > > If anyone could help me, I would be very grateful. > > Thanks in advance, > Vladimir Stokic > -- > View this message in context: > http://www.nabble.com/Accessing-external-applications-from-within-SQLite-triggers-tf4614175.html#a13177010 > Sent from the SQLite mailing list archive at Nabble.com. > > > ----------------------------------------------------------------------------- > To unsubscribe, send email to [EMAIL PROTECTED] > ----------------------------------------------------------------------------- > > ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
