Re: [sqlite] Select and deletion

2007-02-09 Thread DragonK
On 2/8/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: DragonK <[EMAIL PROTECTED]> wrote: > > So, as I understand it, this is supported from version 3.3.8 upwards, right? > Correct. Thanks for straigthening out the issue! :) -- D. Richard Hipp <[EMAIL PROTECTED]>

Re: [sqlite] Select and deletion

2007-02-08 Thread Jay Sprenkle
On 2/8/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: Perhaps what Jay did occurred before [3355] (first released with 3.3.8) and what DragonK did occurred afterwards. http://www.sqlite.org/cvstrac/chngview?cn=3355 That explains it. You have a phenomenal memory for detail! -- The

Re: [sqlite] Select and deletion

2007-02-08 Thread drh
DragonK <[EMAIL PROTECTED]> wrote: > > So, as I understand it, this is supported from version 3.3.8 upwards, right? > Correct. -- D. Richard Hipp <[EMAIL PROTECTED]> - To unsubscribe, send email to [EMAIL PROTECTED]

Re: [sqlite] Select and deletion

2007-02-08 Thread DragonK
On 2/8/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: "Jay Sprenkle" <[EMAIL PROTECTED]> wrote: > On 2/7/07, DragonK <[EMAIL PROTECTED]> wrote: > > > > > > This seems to work... but I'm not sure if it should, that's why I'm > > asking. > > I hope the code will show more exactly what I intend

Re: [sqlite] Select and deletion

2007-02-08 Thread drh
"Jay Sprenkle" <[EMAIL PROTECTED]> wrote: > On 2/7/07, DragonK <[EMAIL PROTECTED]> wrote: > > > > > > This seems to work... but I'm not sure if it should, that's why I'm > > asking. > > I hope the code will show more exactly what I intend to do. Sorry for the > > lack of proper error checking,

Re: [sqlite] Select and deletion

2007-02-07 Thread DragonK
On 2/8/07, Jay Sprenkle <[EMAIL PROTECTED]> wrote: On 2/7/07, DragonK <[EMAIL PROTECTED]> wrote: > > > This seems to work... but I'm not sure if it should, that's why I'm > asking. > I hope the code will show more exactly what I intend to do. Sorry for the > lack of proper error checking, it's

Re: [sqlite] Select and deletion

2007-02-07 Thread Jay Sprenkle
On 2/7/07, DragonK <[EMAIL PROTECTED]> wrote: This seems to work... but I'm not sure if it should, that's why I'm asking. I hope the code will show more exactly what I intend to do. Sorry for the lack of proper error checking, it's just a test program. :) Also, I'm not using any transactions,

Re: [sqlite] Select and deletion

2007-02-07 Thread DragonK
On 2/7/07, anis chaaba <[EMAIL PROTECTED]> wrote: with which language are you trying to do this? to execute the delete statement you can use transactions to ensure atomicity. regards, I'm using a C++ wrapper over sqlite. The code i'm running is the following: SQLiteWrapper w;

Re: [sqlite] Select and deletion

2007-02-07 Thread Jay Sprenkle
On 2/7/07, DragonK <[EMAIL PROTECTED]> wrote: Hello everybody, I'm wondering if the following scenario would work properly: Run a SELECT query on the database and in a loop retrieve each result; for each retrieved result, inside the same loop, execute a DELETE statement for the previously

Re: [sqlite] Select and deletion

2007-02-07 Thread anis chaaba
with which language are you trying to do this? to execute the delete statement you can use transactions to ensure atomicity. regards,