> Subject: RE: [sqlite] How to get the list of rows that were changed during the last UPDATE SQL-command
> Date: Mon, 06 Sep 2004 03:22:45 -0700
> IMHO, you should not do this at the SQL level, but at the OO level. > your "clients" should not change rows, but objects, and the object(s) > would then generate sql to update the database, plus any notifications > to subscribers.
Apologies for the manual reply, but it seems that the daily digest does not reach my mailbox (or I may be impatient). Anyway: You are absolutely right! It just fits nicely with the rest of the stuff. How couldn't I see that earlier..
Thanks!
>> To the point: I use the sqlite database in some C++ object >> that receives >> sql commands from the LAN and executes them. I am trying to create a >> kind of poor-man's observer pattern where the SQL object would send >> information of changed data to all the subscribers who listen that >> particular information (i.e. a single database row). Each row >> will have >> an unique id. So basically I need to extend the functionality so that >> during each UPDATE command I need to get (at least) the >> unique id of the >> row that was changed. Surely this is common operation for SQL users? >>
-- Rami Saarinen