Python Forum
Error :unable to detect undefined names created in spyder ide error at line 2
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Error :unable to detect undefined names created in spyder ide error at line 2
#1
import pymysql
from tkinter import *
from tkinter import messagebox
def search():
    try:
        con=pymysql.connect(user='root',password='Sanjay1*',host='localhost',database='mydatabase')
        cur=con.cursor()
        sql="select * from student where rollnoo='%s'"%rollno.get()
        cur.execute(sql)
        result=cur.fetchone()
        name.set(result[1])
        age.set(result[2])
        e1.configure(state='disabled')
        con.close()
    except:
        messagebox.showinfo('No data avl')
        clear()
def clear():
    rollno.set('')
    name.set('')
    age.set('')
    e1.configure(state='normal')
def add():
    try:
        con=pymysql.connect(user='root',password='Sanjay1*',host='localhost',database='mydatabase')
        cur=con.cursor()
        sql="insert into student values('%s','%s','%s')"%(rollno.get(),name.get(),age.get())
        cur.execute(sql)
        con.commit()
        con.close()
        messagebox.showinfo('success','Record save...')
    except:
        messagebox.showinfo('Error', 'Error in dataentry')
    finally:
        clear()
def update():
    try:
        con=pymysql.connect(user='root',password='Sanjay1*',host='localhost',database='mydatabase')
        cur=con.cursor()
        sql="update student set name = '%s',age='%s' where rollno='%s'" %(name.get(),age.get(),rollno.get())
        cur.execute(sql)
        con.commit()
        con.close()
        messagebox.showinfo('success','Record updated...')
    except:
        messagebox.showinfo('Error', 'Error in dataentry')
    finally:
        clear()
def delete():
    try:
        con=pymysql.connect(user='root',password='Sanjay1*',host='localhost',database='mydatabase')
        cur=con.cursor()
        sql="delete from student where rollno='%s'" %(rollno.get())
        cur.execute(sql)
        con.commit()
        con.close()
        messagebox.showinfo('success','Record deleted...')
    except:
        messagebox.showinfo('Error', 'Error in dataentry')
    finally:
        clear()
w1=Tk()
w1.title('My App')
w1.geometry('500x200')

ptitle=Label(w1,text='''Program to add, modify, delete the records from student table''')

ptitle.grid(row=0,column=0,columnspan=2)

rollno=StringVar()
name=StringVar()
age=StringVar()

l1=Label(w1,text=' RollNo ')
e1=Entry(w1, textvariable=rollno)
l2=Label(w1,text=' Name ')
e2=Entry(w1, textvariable=name)
l3=Label(w1,text=' Age ')
e3=Entry(w1, textvariable=age)

b1=Button(w1,text=' search ', command=search)
b2=Button(w1,text=' Add    ', command=add)
b3=Button(w1,text=' Update ', command=update)
b4=Button(w1,text=' Delete ', command=delete)
b5=Button(w1,text=' clear  ', command=clear)

l1.grid(row=1,column=0)
e1.grid(row=1,column=1)
b1.grid(row=1,column=2)

l2.grid(row=2,column=0)
e2.grid(row=2,column=1)

l3.grid(row=3,column=0)
e3.grid(row=3,column=1)

b2.grid(row=4,column=0)
b3.grid(row=4,column=1)
b4.grid(row=5,column=0)
b5.grid(row=5,column=1)
w1.mainloop()
Error:
Error :unable to detect undefined names created in spyder ide error at line 2 Error : Tk may be undefined or defined from star imports : tkinter
Reply


Messages In This Thread
Error :unable to detect undefined names created in spyder ide error at line 2 - by milind_eac - Jul-30-2019, 04:31 PM
RE: Error :name Tk not found - by milind_eac - Jul-30-2019, 10:29 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Unable to understand the meaning of the line of code. jahuja73 0 314 Jan-23-2024, 05:09 AM
Last Post: jahuja73
  File "<string>", line 19, in <module> error is related to what? Frankduc 9 12,593 Mar-09-2023, 07:22 AM
Last Post: LocklearSusan
  undefined function error JonWayn 5 1,458 Sep-11-2022, 03:38 AM
Last Post: JonWayn
  Undefined Led_Zeppelin 4 1,429 Aug-02-2022, 11:57 AM
Last Post: buran
  Pandas - error when running Pycharm, but works on cmd line zxcv101 1 1,376 Jun-18-2022, 01:09 PM
Last Post: snippsat
  Line 42 syntax error..Help!!1 patpython 4 2,686 Sep-01-2021, 03:22 PM
Last Post: deanhystad
  pandas.errors.ParserError: Error tokenizing data. C error: Expected 9 fields in line Anldra12 9 15,378 Jun-15-2021, 08:16 AM
Last Post: Anldra12
  Error on open of file created with tempfile.TemporaryDirectory() Brian177 4 6,310 Apr-05-2021, 07:12 PM
Last Post: Brian177
  Syntax error on line 29 manwithjeans 3 2,842 Feb-27-2021, 08:28 AM
Last Post: perfringo
  ImportError: /home/pybind11_example.cpython-37m-x86_64-linux-gnu.so: undefined symbol chaitra 2 5,130 Feb-03-2021, 05:14 AM
Last Post: chaitra

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020