You are right I have mend the fault, ^_^
Thank You a lot! Igor Tandetnik wrote: > > liubin liu wrote: >> why is the data file locked after after using transaction? >> >> the last result of printf() is: >> # IN END, ret = 5 >> >> It means to the database file is locked? >> why does it happen after using transaction although using >> sqlite3_finalize()? > > You call sqlite3_prepare_v2 n+2 times, but sqlite3_finalize only once. > You leak statement handles like there's no tomorrow. > > Igor Tandetnik > > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > -- View this message in context: http://www.nabble.com/why-is-the-data-file-locked-after-after-using-transaction--tp24085034p24085861.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users