On 6/28/06, Rob Menegon <[EMAIL PROTECTED]> wrote:
I have an application that displays data retrieved from various SQLite tables. As the data within the tables changes I want these changes reflected in the application real time. Can someone advise on the best way of doing this?
Try sqlite3_update_hook function. (http://www.sqlite.org/capi3ref.html#sqlite3_update_hook) Or you can create a trigger which in turn calls your own C function. (http://www.sqlite.org/capi3ref.html#sqlite3_create_function) Peter