Hi all,
I am having real problems with SQLite on Windows CE (.NET 4.1 and Pocket PC
2003).
I have tried everything and it seems that there is a memory leak with SQLite on
Windows CE.
I have test it with SQLite versions 3.2.2 and 3.3.4 and SQLite seems that it
reserves memory and doesn´t free it after using it, memery is freed only after
the main program has finished.
Take this simple example (it fails also with more complicated ones). I have
test it using a quite big table (20,000 records).
Please i really need help, because my program consumes all the memory and i
need to finish it next week:
Here is the sample source code to test (this is done with EVC 4.0 and a MFC
application)
void CMemoryMDlg::OnButton1()
{
char *errmsg;
char **result;
sqlite3 *db;
int ret, rows, cols;
int n = sqlite3_open("\\mysqlitebd.db", &db);
if (db == 0)
{
MessageBox(_T("Error openning BD"),_T(""),MB_OK);
return;
}
ret = sqlite3_get_table(db, "SELECT * FROM artic", &result,
&rows, &cols, &errmsg);
if (ret != SQLITE_OK)
{
MessageBox(_T("Error en SQL"),_T("Error"),MB_OK);
sqlite3_free(errmsg);
return;
}
else {
MessageBox(_T("Error on SQL
sentence"),_T("Error"),MB_OK);
}
sqlite3_free_table(result);
sqlite3_close(db);
}
Automóviles, telefonía, imagen y sonido, belleza... ¡encuentra gratis todo lo
que necesitas! http://clasificados.wanadoo.es/
