mardi 10 février 2015

iterating through an sqlite database

I'm writing a program to track the amount work i do for reporting purposes. I can update and view the data from the database but what i'm having trouble with is viewing the data one by one and using a button to skip the next result in the table.



for i in c.execute('''SELECT * FROM features ORDER BY id DESC'''):



text.insert('1.0',' {0}:{1},{2}\n'.format(i[0],i[1],i[2]))
'''text.insert('1.0',i)'''


Thanks in advance for all your help


Aucun commentaire:

Enregistrer un commentaire