Re: [sqlite] SQLite memory leak on Windows CE

[Jay Sprenkle]

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.