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