[issue18892] sqlite3, valued records not persisted, default ones are

2013-08-31 Thread Heijink
New submission from Heijink: In the end I tracked down the behaviour with the attached program behaviour with an initially empty table: 7 : insert two records with values in the columns two records show up, # 1,2 as expected 9 : show al records none whereas two are to be expected 8 : add

[issue18892] sqlite3, valued records not persisted, default ones are

2013-08-31 Thread R. David Murray
R. David Murray added the comment: What happens if you actually call commit()? -- nosy: +r.david.murray ___ Python tracker rep...@bugs.python.org http://bugs.python.org/issue18892 ___

[issue18892] sqlite3, valued records not persisted, default ones are

2013-08-31 Thread Heijink
Heijink added the comment: your suggestion is a bit to cryptic for me - you mean intermediate messages from Python: there are none - you mean to change a command in another format newbie with programming experience drop me a program line / show three records where one is your alternative

[issue18892] sqlite3, valued records not persisted, default ones are

2013-08-31 Thread Peter Otten
Peter Otten added the comment: David means you should replace the line conn.commit in your script which does not invoke the method with conn.commit() Side note: as long as you are a newbie it is a good idea to ask on the python mailing list first before adding a report to the bug tracker.

[issue18892] sqlite3, valued records not persisted, default ones are

2013-08-31 Thread R. David Murray
R. David Murray added the comment: Sorry, I didn't mean to be cryptic. Yes, Peter has figured out what I was trying to say. -- ___ Python tracker rep...@bugs.python.org http://bugs.python.org/issue18892 ___

[issue18892] sqlite3, valued records not persisted, default ones are

2013-08-31 Thread Heijink
Heijink added the comment: that did the trick, my confidence is restored. sorry to have bothered you, I could have found in myself, by comparing differences. Just staring blind after many attempts. I did look in the list, but could not find an issue that matched my description of the