Re: [Tutor] tkinter/sqlite3?

2016-08-26 Thread Jim Byrnes
On 08/26/2016 04:22 AM, Alan Gauld via Tutor wrote: On 26/08/16 02:34, Jim Byrnes wrote: Exception in Tkinter callback Traceback (most recent call last): ... File "tk_pwds.py", line 56, in fill_accounts_lb cur.execute('''SELECT Account FROM pwds WHERE Category=? ORDER BY Account COLLA

Re: [Tutor] tkinter/sqlite3?

2016-08-26 Thread Jim Byrnes
On 08/26/2016 02:03 AM, Peter Otten wrote: Jim Byrnes wrote: I am working with Python 3.4.3 on Ubuntu 14.04. I am learning tkinter so I decided to rewrite a program I had written in pythoncard in tkinter. I found that a sqlite3 SELECT statement that works in pythoncard throws an error in tkint

Re: [Tutor] tkinter/sqlite3?

2016-08-26 Thread Alan Gauld via Tutor
On 26/08/16 02:34, Jim Byrnes wrote: > Exception in Tkinter callback > Traceback (most recent call last): ... >File "tk_pwds.py", line 56, in fill_accounts_lb > cur.execute('''SELECT Account FROM pwds WHERE Category=? ORDER BY > Account COLLATE NOCASE''', category) > sqlite3.ProgrammingE

Re: [Tutor] tkinter/sqlite3?

2016-08-26 Thread Peter Otten
Jim Byrnes wrote: > I am working with Python 3.4.3 on Ubuntu 14.04. > > I am learning tkinter so I decided to rewrite a program I had written in > pythoncard in tkinter. I found that a sqlite3 SELECT statement that > works in pythoncard throws an error in tkinter and am wondering why? > > # Fill

[Tutor] tkinter/sqlite3?

2016-08-25 Thread Jim Byrnes
I am working with Python 3.4.3 on Ubuntu 14.04. I am learning tkinter so I decided to rewrite a program I had written in pythoncard in tkinter. I found that a sqlite3 SELECT statement that works in pythoncard throws an error in tkinter and am wondering why? # Fill the accounts listbox from th