Re: Unable to close due to unfinalised statements error msg

Thanks for the suggestion.  I tried it but got the same result.

On 4/29/07, Witold Czarnecki <[email protected]> wrote:
>
> I suggest to change the order to:
>
> db.commit()
> cur.close()
> db.close()
>
> On Sun, 29 Apr 2007 11:09:03 +0200, jim roush <[email protected]> wrote:
>
> > I'm geting the following error message shown below.  The relevant
> > section of
> > code follows that.  Anyone have any ideas?
> >
> >
> > Traceback (most recent call last):
> >   File "C:\markets\source\QuantScan\test.py", line 255, in <module>
> >     db.close()
> > sqlite3.OperationalError: Unable to close due to unfinalised statements
> >
> >
> >     # update ROC table in db
> >     print '\nupdate ROC table in db...\n'
> >     cur = db.cursor()
> >     cur.execute("delete from subind_ROC")
> >
> >     for row in range(0, num_of_subinds):
> >         (subind, si_ROC_10, si_ROC_10_1, si_ROC_10_2, si_ROC_20,
> > si_ROC_20_1, \
> >             si_ROC_20_2, si_ROC_30, si_ROC_30_1, si_ROC_30_2) =
> > si_ROC[row]
> >
> >         cur.execute("INSERT INTO subind_ROC (subind, ROC_10, ROC_10_1, \
> >             ROC_10_2, ROC_20, ROC_20_1, ROC_20_2, ROC_30, ROC_30_1, \
> >             ROC_30_2) Values (?,?,?,?,?,?,?,?,?,?)", \
> >             (subind, si_ROC_10, si_ROC_10_1, si_ROC_10_2, si_ROC_20, \
> >             si_ROC_20_1, si_ROC_20_2, si_ROC_30, si_ROC_30_1,
> > si_ROC_30_2))
> >
> >     top_25()
> >
> >     cur.close()
> >     db.commit()
> >     db.close()
>
>
> _______________________________________________
> pysqlite mailing list
> pysqlite-IAPFreCvJWPBWskQ1e/[email protected]
> http://lists.initd.org/mailman/listinfo/pysqlite
>

_______________________________________________
pysqlite mailing list
pysqlite-IAPFreCvJWPBWskQ1e/[email protected]
http://lists.initd.org/mailman/listinfo/pysqlite