RE: [sqlite] Sqlite - LISTEN/NOTIFY
You could achieve this with a trigger + custom function. MSSQL 2005 now has this ability (though no SQL syntax applies, it's built into the ADO.NET 2.0 provider) and it's a really nice feature. HTH Sam --- We're Hiring! Seeking a passionate developer to join our team building products. Position is in the Washington D.C. metro area. If interested contact [EMAIL PROTECTED] -Original Message- From: Shilpa Sheoran [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 27, 2007 5:09 PM To: sqlite-users@sqlite.org Subject: [sqlite] Sqlite - LISTEN/NOTIFY All, Does sqlite implement LISTEN or NOTIFY commands? Basically if one application modifies the database will sqlite notify other interested applications about the modification? Shilpa - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] Sqlite - LISTEN/NOTIFY
Why not youself take charge of this work.that's not be somehow complex. All, Does sqlite implement LISTEN or NOTIFY commands? Basically if one application modifies the database will sqlite notify other interested applications about the modification? Shilpa - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] Sqlite - LISTEN/NOTIFY
On 6/27/07, Shilpa Sheoran <[EMAIL PROTECTED]> wrote: All, Does sqlite implement LISTEN or NOTIFY commands? Basically if one application modifies the database will sqlite notify other interested applications about the modification? I do not believe that SQLite implements the non-standard extension that Postgres has for LISTEN/NOTIFY. From http://www.postgresql.org/docs/7.4/static/sql-notify.html : "Compatibility:There is no NOTIFY statement in the SQL standard."