Working on a database program for work, it saves letters.

from Tkinter import *
import sqlite3
#Witten by Steve Atchison 11/19/2013 for SHAWNEE COUNTY
def listletters():
    connect =sqlite3.connect("LETTER_data.db")
    cur = connect.cursor()
    letter = cur.execute("SELECT * FROM letters")
    cleargui()
    for row in letter:
        textwindow.insert("500.0",row[2])
   
def cleargui():
    textwindow.delete("1.0",END)
    deed.delete(0,END)
    pinnum.delete(0,END)
   
def connectdb():
    connect = sqlite3.connect("LETTER_data.db")
    cur = connect.cursor()
    cur.execute("CREATE TABLE IF NOT EXISTS letters(quickref text,pin text, letter text)")

def addtodatabase():
    quickref=deed.get()
    pin=pinnum.get()
    letter=textwindow.get("1.0",END)
   
    connect = sqlite3.connect("LETTER_data.db")
    cur=connect.cursor()
    cur.execute("INSERT INTO letters VALUES(?,?,?)",([quickref,pin,letter]))
    connect.commit()
    cleargui()

def getdata():
    connect = sqlite3.connect("LETTER_data.db")
    cur=connect.cursor()
    thedata = cur.execute("SELECT * FROM letters")
    for row in thedata:
        textwindow.insert("500.0",row[0]+"\n"+row[1]+"\n")

def addlettertotext():
    f=open('theletter.txt','r')
    for line in f:
        textwindow.insert("50.0",line)

def findquick():  
    cleargui()
    pinnum=quickent.get()
    connect = sqlite3.connect("LETTER_data.db")
    cur=connect.cursor()
    theletter = cur.execute("SELECT letter FROM letters where pin = (?)",([pinnum]))
    for line in theletter:
        textwindow.insert("50.0",line)
    quickent.delete(0,END)

def listpins():
    cleargui()
    connect=sqlite3.connect("LETTER_data.db")
    cur=connect.cursor()
    parcelnum = cur.execute("SELECT pin FROM letters")
    for row in parcelnum:
        print(row[0])
        textwindow.insert("100.0",row[0]+"\n")   

   
connectdb()#creates a database if none exists.

root=Tk()
root.title("LETTER DATABASE")
root.config(bg='green')
root.geometry('900x700')

top=Toplevel(root)
top.geometry("300x200")
top.config(bg="orange")
top.title("Add letter to database form")

top2=Toplevel(root)
top2.geometry("300x100")
top2.config(bg="light blue")
top2.title("List options")

lbl=Label(top,text="Quick Ref Number").pack()

deed=Entry(top)
deed.pack()

lbl2=Label(top,text="Parcel number").pack()
pinnum=Entry(top)
pinnum.pack()

textwindow=Text(root,width='800',height=35,background='white')
textwindow.pack()

add_to_txt=Button(top,text="IMPORT theletter.txt", command=addlettertotext)
add_to_txt.pack()

addtodatabase=Button(top,text='Add letter to Database ',command=addtodatabase)
addtodatabase.pack()

getpidbtn=Button(top2,text="List Letters", command= listletters)
getpidbtn.pack()

btn3=Button(root,text="Clear window",command=cleargui)
btn3.pack()

btn5=Button(root,text="Find using PIN", command=findquick)
btn5.pack()

listpinbtn=Button(top2,text="List PIN numbers",command=listpins)
listpinbtn.pack()

quickent=Entry(root)
quickent.pack()
root.mainloop()
#DON'T FORGET TO ADD THE QUICK REF NUMBER

VIDEO OF MY PROGRAM

MY PROGRAM NOW SAVES TO A DATA BASE

from Tkinter import *
import sqlite3
#Witten by Steve Atchison 11/16/2013
def cleargui():
    textwindow.delete("1.0",END)
    deed.delete(0,END)

def connectdb():
    connect = sqlite3.connect("mydata.db")
    cur = connect.cursor()
    cur.execute("CREATE TABLE IF NOT EXISTS mytable(bookpage text, description text)")

def addtodatabase():
    deednum=deed.get()
    description=textwindow.get("1.0",END)
    connect = sqlite3.connect("mydata.db")
    cur=connect.cursor()
    cur.execute("INSERT INTO mytable VALUES(?,?)",([deednum,description]))
    connect.commit()
    cleargui()

def getdata():
    connect = sqlite3.connect("mydata.db")
    cur=connect.cursor()
    thedata = cur.execute("SELECT * FROM mytable")
    for row in thedata:
        textwindow.insert("100.0",row[0]+"\n"+row[1]+"\n")

connectdb()#creates a database if none exists.

root=Tk()
root.title("PROPERTY DESCRIPTION DATABASE")
root.config(bg='lightblue')
lbl=Label(root,text="Deed number").pack()
deed=Entry(root,text="Deed number")
deed.pack()

textwindow=Text(root,background='white')
textwindow.pack()

btn=Button(root,text='Add to Database ',command=addtodatabase)
btn.pack()

btn2=Button(root,text="Show data",command=getdata)
btn2.pack()

btn3=Button(root,text="Clear window",command=cleargui)
btn3.pack()
root.mainloop()

Added Buttons and new functions to my Text Editor

from Tkinter import *
def cleargui():
    textwindow.delete("1.0",END)

def createfile(): #Creates a text file if none exitst.
    f=open('propertydescripts.txt','a')
   
   
def save_changes():
    f=open('propertydescripts.txt','a')
    theletter=textwindow.get("1.0",END)
    f.write('-----------------------------------------------------\n')
    f.write(theletter)
    f.close()
    cleargui()
    print("Edits saved ")

def loadletter():
    f=open('propertydescripts.txt','r')
  
    for line in f:
        textwindow.insert("300.0",line)#change the 300 to match file length

def showtext():
    f=open('propertydescripts.txt','a')
   
createfile()  
root=Tk()
root.title("Steve's simple text editor.")
root.config(bg='lightblue')
textwindow=Text(root,background='white')
textwindow.pack()
btn=Button(root,text='Append ',command=save_changes)
btn.pack()

btn2=Button(root,text="Show ", command=loadletter)
btn2.pack()

btn3=Button(root,text="Clear ", command=cleargui)
btn3.pack()

showtext()

root.mainloop()