Thanks. I need to increment the value of recNo and use it in that function to get the record. That is why I tried incrementing recNo within that function. I tried passing recNo as a parameter and then using local variable x=recNo, incrementing x and then recNo=x but have this error:
TypeError: fetchRecord() missing 1 required positional argument: 'recNo'
TypeError: fetchRecord() missing 1 required positional argument: 'recNo'
ef fetchRecord(recNo): recBox.delete(0,END) eName.delete(0,END) #entry boxes eMeaning.delete(0,END) ePronounce.delete(0,END) ePeriod.delete(0,END) eGroup.delete(0,END) eSize.delete(0,END) eLived.delete(0,END) eDiet.delete(0,END) eFossils.delete(0,END) factFile.delete(1.0,END) #Textbox x=recNo x += 1 recNo = x conn=sqlite3.connect('dinobase.db') c=conn.cursor() c.execute('SELECT * FROM dino WHERE record = recNo') rows=c.fetchall() for row in rows: recBox.insert(0,row[0]) eName.insert(0,row[1]) eMeaning.insert(0,row[2]) ePronounce.insert(0,row[3]) ePeriod.insert(0,row[4]) eGroup.insert(0,row[5]) eSize.insert(0,row[6]) eLived.insert(0,row[7]) eDiet.insert(0,row[8]) eFossils.insert(0,row[9]) factFile.insert(1.0,row[10]) c.close() conn.close()Not the best way I guess.