Re: [sqlite] SQLite memory leak on Windows CE

[John Stanton]

You might look to recoding your application to not use get_table, a 
memory hog.  Instead use step in a loop.

Jay Sprenkle wrote:
On 3/14/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
Hi all,
I am having real problems with SQLite on Windows CE (.NET 4.1 and Pocket PC 
2003).


ret = sqlite3_get_table(db, &quot;SELECT * FROM artic&quot;, &amp;result, &amp;rows, 
&amp;cols, &amp;errmsg);
if (ret != SQLITE_OK)
{
MessageBox(_T(&quot;Error en SQL&quot;),_T(&quot;Error&quot;),MB_OK);
sqlite3_free(errmsg);


You might call sqlite3_free_table(result) here. Without looking at the source
code it might have allocated a result even though there was an error.



return;
}
else {
MessageBox(_T(&quot;Erroron SQL sentence&quot;),_T(&quot;Error&quot;),MB_OK);
}
sqlite3_free_table(result);
sqlite3_close(db);
}



Did you look at the source code for sqlite3_get_table()?
It's easy to get and may be very helpful.