On March 14, 2006 01:49 pm, [EMAIL PROTECTED] wrote:
> Hello again,
> Thank for your answers:
> first of all thank you who pointed that i should use a close(db) at
> line 17 and call sqlite3_free_table(result) even if there was an
> error, but these solutions didn´t solve my problem (the execution
> code never reached that point because ret value was always
> SQLITE_OK). Do anyone of you work with SQLite on Windows CE?
No, I don't have win ce either.
However, I looked at the sqlite code and there may be a bug.
In SQLite3.3.4 go to:
"src\table.c" line 192 and change "azResult--;"
----changed_from-----------------------------
190 if( azResult ){
191 int i, n;
192 azResult--;
193 if( azResult==0 ) return;
194 n = (int)azResult[0];
----changed_to-----------------------------
190 if( azResult ){
191 int i, n;
192 azResult -= sizeof(char*); <----changed
193 if( azResult==0 ) return;
194 n = (int)azResult[0];
Recompile sqlite and try again.
Let us know if it works.
