SQLite3, data not found

[jim-on-linux]

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