Member Avatar for mca3

:( hi, i am beginner in python and i am getting one error
sql =cursor.execute("INSERT INTO main12 VALUES('self.temp','self.entry2')")
sqlite3.IntegrityError: column num is not unique

while entering two value from text box to my database main12 where i hav only 2 fields num and time .i first create tool.sqlite and then create create my table main12 .

help me............

  • 2 Contributors
  • 1 Reply
  • 73 Views
  • 4 Days Discussion Span
  • Latest Post Latest Post by richieking
Member Avatar for richieking

Do this....

cursor.execute("INSERT INTO main12 VALUES(?,?)",(self.temp,self.entry2))
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.