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

Reply via email to