Maybe adding "order by rowid" to your select statement can help avoid "sawing
off the branch you are sitting on". Unless you need to update rowids...
-Ursprüngliche Nachricht-
Von: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] Im
Auftrag von Jens Alfke
Gesendet: Dien
On 31 Jan 2017, at 5:26am, Jens Alfke wrote:
> I don’t follow. What’s the “resource” you’re talking about here?
In your case, the NSEnumerator .
Would the solution I proposed in my post work for you ?
Simon.
___
sqlite-users mailing list
sqlite-user
> On Jan 30, 2017, at 9:10 PM, Simon Slavin wrote:
>
> Nope. Cannot do that. Any number of things might happen between the first
> _step() and the _finalize(). For all you know someone might delete the
> object the iterator is currently on instead of just updating it. Then where
> would t
> On Jan 30, 2017, at 8:03 PM, Rowan Worth wrote:
>
> If the iterator isn't exhausted, how do you know when to dispose the
> sqlite3_stmt?
The iterator (which is an Objective-C NSEnumerator object) will be deleted
shortly after it exits scope. Some of the refcounting is deferred via the
auto
On 31 Jan 2017, at 3:29am, Jens Alfke wrote:
> I’ve discovered (after some debugging) that if I iterate over the the rows in
> a table using sqlite3_step, and update each row after it’s returned, Bad
> Stuff happens. Specifically, my query is just getting the first row over and
> over and ove
The iterator pattern has another caveat when applied to sqlite:
foreach (row in statement) {
if (isMatch(row)) {
return true
}
}
return false
If the iterator isn't exhausted, how do you know when to dispose the
sqlite3_stmt? There are other ways to manage the statement
I’ve just run headlong in to the issues described in "No Isolation Between
Operations On The Same Database Connection”. Specifically, I’ve discovered
(after some debugging) that if I iterate over the the rows in a table using
sqlite3_step, and update each row after it’s returned, Bad Stuff happe
It's an iBook, so some version of OS X I would guess. From a little
searching online, 10.2 was the last release in 2002, and it seems that it
may have included GCC 3.3. GCC 3.3 did not fully support C99 (as its
release notes indicated "A few more ISO C99 features now work correctly."
Of course, thi
On Sun, 29 Jan 2017 21:40:23 -0500
Richard Hipp wrote:
> On 1/29/17, James K. Lowden wrote:
> >
> > I wonder what pricey embedded environment both supports dlopen(2)
> > and does not support C99, in this day and age.
>
> One of the test platforms for SQLite is an old iBook I bought back in
> ap
> Mensaje original
> De: Dan Kennedy
> Para: sqlite-users@mailinglists.sqlite.org
>
> On 01/30/2017 05:39 PM, a...@zator.com wrote:
>> Hi list:
>>
>> Building with SQLite v. 3.16.2 and MS VC++ 2015 (v 14.0) there appeared a
>> linker error:
>>
>> Error LNK2019 external simbol _sqlite3F
On 01/31/2017 12:48 AM, Nir Paz wrote:
Hi All,
I get the next error: SQLITE_CANTOPEN when calling sqlite3_open_v2 with
filename exceeding 512 characters.
Linux doesn't have that limit, my thought is to change the define of
MAX_PATHNAME, is there a better option?
I don't think there is a bette
Hi All,
I get the next error: SQLITE_CANTOPEN when calling sqlite3_open_v2 with
filename exceeding 512 characters.
Linux doesn't have that limit, my thought is to change the define of
MAX_PATHNAME, is there a better option?
Thanks,
Nir
___
sqlite-users
From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On
Behalf Of Hick Gunter
>>>Integer promotion is usually ok between integers of the same signedness.
For some definition of 'OK'.
>>>However, in
unsigned char uns = 0xff;
long val = uns;
>>>what should be t
On 01/30/2017 05:39 PM, a...@zator.com wrote:
Hi list:
Building with SQLite v. 3.16.2 and MS VC++ 2015 (v 14.0) there appeared a
linker error:
Error LNK2019 external simbol _sqlite3FkReferences unresolved in function
_sqlite3Insert
Who belong (I suppose) to a compiler warning:
line 109039:
Hi list:
Building with SQLite v. 3.16.2 and MS VC++ 2015 (v 14.0) there appeared a
linker error:
Error LNK2019 external simbol _sqlite3FkReferences unresolved in function
_sqlite3Insert
Who belong (I suppose) to a compiler warning:
line 109039: warning C4013: 'sqlite3FkReferences' undefined
>-Ursprüngliche Nachricht-
>Von: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] Im
>Auftrag von James K. Lowden
>Gesendet: Freitag, 27. Jänner 2017 20:08
>An: sqlite-users@mailinglists.sqlite.org
>Betreff: Re: [sqlite] BUG: Illegal initialization in icu.c : sqlite3IcuIn
16 matches
Mail list logo