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