Re: [sqlite] Does changing the db change result sets?

2008-07-21 Thread Dennis Cote
Roger Binns wrote: > > The cursor object in apsw wraps a prepared statement. Since the cursor > gets reused the earlier results are no longer available: > > cursor.execute("select * from numbers") > ... > cursor.execute("delete from numbers where no=5") > OK, that makes sense. > >

Re: [sqlite] Does changing the db change result sets?

2008-07-18 Thread Dennis Cote
Nikolaus Rath wrote: > > So as soon as I make a change in the database, I do not get any more > results. If I understood you correctly, I should have gotten (4,) > instead. > > Is this a bug? > It is probably a bug (or a design decision) in the apsw wrapper. The following program produces the

Re: [sqlite] Does changing the db change result sets?

2008-07-18 Thread Nikolaus Rath
"Igor Tandetnik" <[EMAIL PROTECTED]> writes: > "Nikolaus Rath" <[EMAIL PROTECTED]> wrote in > message news:[EMAIL PROTECTED] >> What happens if >> >> 1. I prepare and execute a select statement >> 2. I retrieve a couple of rows >> 3. I execute a new query that would change the result of the >>

Re: [sqlite] Does changing the db change result sets?

2008-07-17 Thread Igor Tandetnik
"Stephen Woodbridge" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Igor Tandetnik wrote: >> "Nikolaus Rath" <[EMAIL PROTECTED]> wrote in >> message news:[EMAIL PROTECTED] >>> What happens if >>> >>> 1. I prepare and execute a select statement >>> 2. I retrieve a couple of rows >>>

Re: [sqlite] Does changing the db change result sets?

2008-07-17 Thread Stephen Woodbridge
Igor Tandetnik wrote: > "Nikolaus Rath" <[EMAIL PROTECTED]> wrote in > message news:[EMAIL PROTECTED] >> What happens if >> >> 1. I prepare and execute a select statement >> 2. I retrieve a couple of rows >> 3. I execute a new query that would change the result of the >>query in 1 > > On the

Re: [sqlite] Does changing the db change result sets?

2008-07-17 Thread Igor Tandetnik
"Nikolaus Rath" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > What happens if > > 1. I prepare and execute a select statement > 2. I retrieve a couple of rows > 3. I execute a new query that would change the result of the >query in 1 On the same connection, I assume. > 4. I

[sqlite] Does changing the db change result sets?

2008-07-17 Thread Nikolaus Rath
Hello, What happens if 1. I prepare and execute a select statement 2. I retrieve a couple of rows 3. I execute a new query that would change the result of the query in 1 4. I continue to retrieve the results of 1) Will I get the results as if step 3 hasn't happened, is the result