"Wesley W. Terpstra" <[EMAIL PROTECTED]> wrote: > > The approach I'd much prefer is to register a trigger to update the > GUI... >
Note that the trigger runs on the client-side of the process that makes the change - not on the client side of the process that is implementing the GUI. Nevertheless, your technique is useful for doing things like implementing Undo/Redo. See, for example, http://www.sqlite.org/cvstrac/wiki?p=UndoRedo You might implement something like this then have your GUI process poll only changes table. The changes table will normally be empty, except after some other process makes a change. So when the changes table is non-empty, that is the GUI process's cue to redraw its screen based on the latest database content. The details are left as an exercise to the reader... -- D. Richard Hipp <[EMAIL PROTECTED]> ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
