Python help,
I just started working with SQLite3 and ran into
this problem.
Below, the first select produces results but,
after closing then re-opening the database the
select produces an empty list. Anyone know the
reason ??
The table seems to be empty.
import sqlite3
con = sqlite3.connect('myData')
cursor = con.cursor()
cursor.execute ("""create table data
(recordNo varchar,
caseNo varchar)""");
record = ['A', 'B']
cursor.execute("insert into data values (?,?)",
record ) ;
cursor.execute("select * from data ");
print cursor.fetchall();
con.close()
con = sqlite3.connect('myData')
cursor = con.cursor()
cursor.execute("select * from data");
print cursor.fetchall();
jim-on-linux
--
http://mail.python.org/mailman/listinfo/python-list
