try finalize at the end instead of reset.
--- On Wed, 2/11/09, [email protected] <[email protected]> wrote: > From: [email protected] <[email protected]> > Subject: [sqlite] Unab to close data base due to unfinalized statements > To: [email protected] > Date: Wednesday, February 11, 2009, 2:28 AM > Hi , > i am using sqlite with vc++, i tried to insert a row into > data base with prepared statement using bind operations, i > reset the statement after using it but when i try to close > DB it is giving error "Unable to close data base due to > unfinalized statements" > i userd query like > > > _T("INSERT INTO?MY_TABLE VALUES(?, ?, ?, ?, ?, ?, ?, > ?, ?)") > > "INSERT INTO?MY_TABLE VALUES(?, ?, ?, ?, ?, ?, ?, ?, > ?)") > > and bind operations on it. > > Regards > > > Krishna Kumar T M > ________________________________________________________________________ > Don't let your email address define you - Define > yourself at http://www.tunome.com today! > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

