Re: [sqlite] sqlite3_finalize (pStmt=0x28) at ../src/vdbeapi.c:204

2009-02-12 Thread Dan
On Feb 13, 2009, at 11:49 AM, Joanne Pham wrote: > Hi All, > We have an application is used SQLite 3.5.9 and our program is > crashed on > "sqlite3_finalize (pStmt=0x28) at ../src/vdbeapi.c:204" and I don't > know why it crashed on this line. > Do you have any information about why it is

[sqlite] sqlite3_finalize (pStmt=0x28) at ../src/vdbeapi.c:204

2009-02-12 Thread Joanne Pham
Hi All, We have an application is used SQLite 3.5.9 and our program is crashed on "sqlite3_finalize (pStmt=0x28) at ../src/vdbeapi.c:204" and I don't know why it crashed on this line. Do you have any information about why it is crashed on sqlite3_finalize at 204 vdbeapi. Thanks in advance for

[sqlite] SQLite- Memory heap usage query

2009-02-12 Thread jaya_kumar
I am trying to find the peak heap usage for creating a table with few entries and when calculated the peak heap usage increases as the numbers of items inserted into the table increases. Following are the steps done, 1. Table created 2. Table updated by insert statement 3. Query for a single

Re: [sqlite] [SQLITE] Require Help

2009-02-12 Thread MikeW
Roger Binns writes: > > > deepak dhananjaya wrote: > > its crashing while opening... > > Note: its on Symbian platform.. > > That code fundamentally works everywhere else. > > http://www.catb.org/~esr/faqs/smart-questions.html > > Roger > Obviously my previous 'helpful'

Re: [sqlite] Query Optimization Help

2009-02-12 Thread Mike Eggleston
On Wed, 11 Feb 2009, inZania might have said: > > Hello, > > I have a query that is slowing down my application significantly; in some > cases, it takes 20+ seconds (this is in a SQLite database in an iPhone app, > which is why it is so slow - the iPhone doesn't have as much system >