Re: [sqlite] How to get the list of rows that were changed during the last UPDATE SQL-command

2004-09-22 Thread Rami Saarinen
> From: Mike Shaver > Subject: Re: [sqlite] How to get the list of rows that were changed during the last UPDATE SQL-command > Date: Wed, 08 Sep 2004 05:11:08 -0700 >On Mon, 06 Sep 2004 12:17:07 +0300, Rami Saarinen <[EMAIL PROTECTED]> >wrote: >> Should I use trigger

Re: [sqlite] How to get the list of rows that were changed during the last UPDATE SQL-command

2004-09-08 Thread Mike Shaver
On Mon, 06 Sep 2004 12:17:07 +0300, Rami Saarinen <[EMAIL PROTECTED]> wrote: > Should I use triggers? But they seem limited as the only allow the > execution of SQL statements.. so I could have a separate table where > I'd collect the changed information and process the table after the > UPDATE. Th

RE: [sqlite] How to get the list of rows that were changed during the last UPDATE SQL-command

2004-09-07 Thread Rami Saarinen
> From: CARIOTOGLOU MIKE > 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

RE: [sqlite] How to get the list of rows that were changed during the last UPDATE SQL-command

2004-09-06 Thread CARIOTOGLOU MIKE
n [mailto:[EMAIL PROTECTED] > Sent: Monday, September 06, 2004 12:17 PM > To: [EMAIL PROTECTED] > Subject: [sqlite] How to get the list of rows that were changed during > the last UPDATE SQL-command > > > First of all I have to state that I am not a SQL professional so I may > b

[sqlite] How to get the list of rows that were changed during the last UPDATE SQL-command

2004-09-06 Thread Rami Saarinen
First of all I have to state that I am not a SQL professional so I may be asking the silliest thing in the world, but you never learn if you dont ask. Right? 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