Re: sqlite3 puzzle

2013-01-15 Thread Rob Day
On 15 January 2013 07:09, llanitedave llanited...@veawb.coop wrote: So I put the following test code in my initialization method: # open database file self.geologger_db = sqlite3.connect('geologger.mgc') self.db_cursor = self.geologger_db.cursor() self.foreign_key_status =

Re: sqlite3 puzzle

2013-01-15 Thread llanitedave
On Tuesday, January 15, 2013 6:36:51 AM UTC-8, Rob Day wrote: On 15 January 2013 07:09, llanitedave llanited...@veawb.coop wrote: So I put the following test code in my initialization method: # open database file self.geologger_db = sqlite3.connect('geologger.mgc')

Re: sqlite3 puzzle

2013-01-15 Thread Rob Day
On 15 January 2013 15:51, llanitedave llanited...@veawb.coop wrote: Thanks for the suggestion, Rob, but that didn't make any difference. I've never had an issue with putting the execute object into a variable and calling fetch on that variable. I can accept reality if it turns out that

Re: sqlite3 puzzle

2013-01-15 Thread inq1ltd
On Monday, January 14, 2013 11:09:28 PM llanitedave wrote: I'm trying to get an application working in Python 2.7 and wx.Python which contains an embedded sqlite3 file. There are a few tables with foreign keys defined. In looking at the sqlite3 documentation, it says Assuming the library

Re: sqlite3 puzzle

2013-01-15 Thread llanitedave
On Tuesday, January 15, 2013 9:13:13 AM UTC-8, Rob Day wrote: On 15 January 2013 15:51, llanitedave llanited...@veawb.coop wrote: Thanks for the suggestion, Rob, but that didn't make any difference. I've never had an issue with putting the execute object into a variable and calling

Re: sqlite3 puzzle

2013-01-15 Thread Rob Day
Glad I could help! evangelism Using a local source control system like git, bzr or hg is really useful in situations like these - it's far, far easier to debug issues of the form I made changes and now it's broken when you can do `git diff yesterday's-version today's-version` and see exactly what

Re: sqlite3 puzzle

2013-01-15 Thread llanitedave
Yabut I'm talking about changes I'd made 30 seconds before to code I'd written 5 minutes before. My short-term memory is nothing to write home about, even if I could remember my mailing address! On Tuesday, January 15, 2013 2:27:28 PM UTC-8, Rob Day wrote: Glad I could help!

sqlite3 puzzle

2013-01-14 Thread llanitedave
I'm trying to get an application working in Python 2.7 and wx.Python which contains an embedded sqlite3 file. There are a few tables with foreign keys defined. In looking at the sqlite3 documentation, it says Assuming the library is compiled with foreign key constraints enabled, it must