Bugs item #1738670, was opened at 2007-06-17 15:08 Message generated for change (Tracker Item Submitted) made by Item Submitter You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=105470&aid=1738670&group_id=5470
Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: Documentation Group: Python 2.5 Status: Open Resolution: None Priority: 5 Private: No Submitted By: Mark Carter (comcol) Assigned to: Nobody/Anonymous (nobody) Summary: sqlite3 doc fix Initial Comment: I ran the example given at http://docs.python.org/lib/module-sqlite3.html but it didn't affect the database because no commit() was made. This is a "gotcha" that will affect others, too. I recommend appending the example: ---begin conn = sqlite3.connect('/tmp/example') # ... c = conn.cursor() # Create table c.execute('''create table stocks (date text, trans text, symbol text, qty real, price real)''') # Insert a row of data c.execute("""insert into stocks values ('2006-01-05','BUY','RHAT',100,35.14)""") ---end with the lines: # commit the changes, and close out c.close() conn.commit() # make the changes "stick" conn.close() ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=105470&aid=1738670&group_id=5470 _______________________________________________ Python-bugs-list mailing list Unsubscribe: http://mail.python.org/mailman/options/python-bugs-list/archive%40mail-archive.com
