The query that is failing is fairly simple:
sprintf( strStmt, "select count(*) from sqlite_master where type = 'table'
and tbl_name = '%s'", tableName);
I have checked and there are no "loose" queries hanging around and
furthermore this is the first query that is executed by the program;
To
On Thu, 2007-04-05 at 05:37 -0700, pompomJuice wrote:
> Yes this is with the 3.3.14 code. I initially got the problem with the 3.3.12
> code so I just upgraded to the 3.3.14 code but it behaves exactly the same.
>
> Just to recap, my proposed fix was
> //---
> while( rc == SQLITE_SCHEMA )
> rc
Yes this is with the 3.3.14 code. I initially got the problem with the 3.3.12
code so I just upgraded to the 3.3.14 code but it behaves exactly the same.
Just to recap, my proposed fix was
//---
while( rc == SQLITE_SCHEMA )
rc = prepare_v2;
// Some generic rc error checking here for
On Thu, 2007-04-05 at 04:04 -0700, pompomJuice wrote:
> Ok.
>
> I went and re-prepared the statement anyway even though the documentation
> says it won't work. This trick only works if you finalize the failed
> statement after the step command. Otherwhise you keep on getting
> SQLITE_SCHEMA
Ok.
I went and re-prepared the statement anyway even though the documentation
says it won't work. This trick only works if you finalize the failed
statement after the step command. Otherwhise you keep on getting
SQLITE_SCHEMA errors which might cause and endless loop if so implemented.
Hello.
I recently rewrote most of my SQLite wrappers to now ignore SCHEMA errors,
as these are now automagically handled by the new sqlite3_prepare_v2 API.
The logic changes were simple so I did not bother to test it and continued
with development. Now that development is complete and testing
6 matches
Mail list logo
