Lloyd, You need at some point to call the sqlite3_finalize function. I don't use wxSqlite, but if it's not handled by the destructor of the recordset then there should be a method, possibly called finalize or close, that needs to be called. I recommend consulting the documentation for wxSQLite since most of the wxWidgets components are pretty well documented.
Clay Dowling Lloyd said: > I have tracked down the problem and found th following. > > I have a select statement which stores the result set in a pointer > variable. If the result set of select statement is empty, the program > executes, otherwise it gives a Database Locked error. > > How can I solve this problem ? > > Thanks again, > Lloyd. > > > > On Wed, 2006-11-15 at 14:46 +0530, Lloyd wrote: >> Hi, >> I have opened a database, created tables and inserted data to it in a >> single transaction. Then I have closed the data base. Then I reopened >> the database and tried to update the table entries. But it throws an >> exception called Database Locked. Where can be the mistake? I am using >> wxSqlite3 wrapper class. All these are performed from a single program. >> >> Thanks, >> Lloyd. >> >> >> ______________________________________ >> Scanned and protected by Email scanner >> >> ----------------------------------------------------------------------------- >> To unsubscribe, send email to [EMAIL PROTECTED] >> ----------------------------------------------------------------------------- > > > ______________________________________ > Scanned and protected by Email scanner > > ----------------------------------------------------------------------------- > To unsubscribe, send email to [EMAIL PROTECTED] > ----------------------------------------------------------------------------- > > -- Simple Content Management http://www.ceamus.com ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
