SQLite3, data not found

[jim-on-linux]

from John Clark
use con.commit()

Thanks John, 
this works
jim-on-linux




On Friday 16 March 2007 17:55, jim-on-linux wrote:
> 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