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.
>
>
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
"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
>>
"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
>>>
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
"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
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
7 matches
Mail list logo