Data entered in SQLite3 is not shown in PyQT4 application
I made a small desktop application PyQt4 where I insert data in db sqlite3, but when I query these data that were previously entered, they do not appear on the display screen of the same, only when I exit the application and enter again to make the query is that the data appear. I can't identify why this is happening, could anyone help me in this case? Below is part of the input code of the data in the DB.
sql_ins_dados_q = "INSERT INTO quinas(concurso,data_sorteio,bola_1,bola_2,bola_3,bola_4,bola_5,arrecadacao,ganhadores_quina,rateio_quina,ganhadores_quadra,rateio_quadra,ganhadores_terno,rateio_terno)
VALUES(?,?,?,?,?,?,?,?,?,?,?,?,?,?)"
while i < len(trt_htm_q.concursos):
insere_dados_q.cur.execute("PRAGMA synchronous = OFF")
insere_dados_q.cur.execute(sql_ins_dados_q,(trt_htm_q.concursos[i],
trt_htm_q.concursos[i+1],
trt_htm_q.concursos[i+2],
trt_htm_q.concursos[i+3],
trt_htm_q.concursos[i+4],
trt_htm_q.concursos[i+5],
trt_htm_q.concursos[i+6],
trt_htm_q.concursos[i+7],
trt_htm_q.concursos[i+8],
trt_htm_q.concursos[i+9],
trt_htm_q.concursos[i+10],
trt_htm_q.concursos[i+11],
trt_htm_q.concursos[i+12],
trt_htm_q.concursos[i+13]))
i += 14
c += 1
insere_dados_q.conn.commit()
insere_dados_q.cur.close()
insere_dados_q.conn.close()
0