On 8/21/06, Laura Longo <[EMAIL PROTECTED]> wrote:
Yes, I use a wrapper around the function sqlite3_get_table which, if the return code if different from 0, retries to execute the query calling again sqlite3_get_table doing a 'while'. Besides, each query is written in a file for debugging purpose (in this way I've seen the problem). Here is the code that I use.
This looks like it should work fine. The only thing that concerns me is this could be a very long loop if something locks the table or there's an error that's not recoverable. It would sit there forever retrying something that will never be fixed. Some operations will cause the database to be reorganized and will return schema errors when you run a prepared statement. You have to re prepare your statement to get it to work. I'm not sure if that applies to get_table though. I see the calls to free the memory if it fails. Do you free the memory used after success too? You might look through the source code for sqlite3_get_table(). You could put some debugging output there to help figure out what's going wrong. -- SqliteImporter and SqliteReplicator: Command line utilities for Sqlite http://www.reddawn.net/~jsprenkl/Sqlite Cthulhu Bucks! http://www.cthulhubucks.com ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
