Re: How to trap this error (comes from sqlite3)

2016-02-09 Thread cl
Peter Otten <__pete...@web.de> wrote: > c...@isbd.net wrote: > > > It's absolutely right, there is a non-UTF character in the column. > > However I don't want to have to clean up the data, it would take > > rather a long time. How can I trap the error and just put a Null or > > zero in the datagr

Re: How to trap this error (comes from sqlite3)

2016-02-09 Thread Mark Lawrence
On 09/02/2016 11:57, c...@isbd.net wrote: I have the following code snippet populating a wxPython grid with data from a database. :- # # # populate grid with data # all = self.cur.execute("SELECT * from " + table + " ORDER by id ") for row in

Re: How to trap this error (comes from sqlite3)

2016-02-09 Thread Peter Otten
c...@isbd.net wrote: > I have the following code snippet populating a wxPython grid with data > from a database. :- > > # > # > # populate grid with data > # > all = self.cur.execute("SELECT * from " + table + " ORDER by id ") > for row in all: >

How to trap this error (comes from sqlite3)

2016-02-09 Thread cl
I have the following code snippet populating a wxPython grid with data from a database. :- # # # populate grid with data # all = self.cur.execute("SELECT * from " + table + " ORDER by id ") for row in all: row_num = row[0] ce