Hi all,
I'm working on a sqlite3 with python program.Here is the code snippet
------------
def save_point(self):
self.db.execute("savepoint pt;")
print "Save point created"
self.cursor.execute("insert into STK values(33)")
self.db.execute("rollback to savepoint pt;")
--------------------
which produces following error message
------------------
Insertion successful.
Save point created
Traceback (most recent call last):
File "open_db.py", line 75, in <module>
obj1.save_point()
File "open_db.py", line 61, in save_point
self.db.execute("rollback to savepoint pt;")
sqlite3.OperationalError: no such savepoint: pt
-------------
How to fix this?
--
----
Cheers,
Lakshmipathi.G
www.giis.co.in
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users