Re: [sqlite] Raise is not working

2009-07-13 Thread Kees Nuyt
On Sun, 12 Jul 2009 18:03:14 -0700, "Jim Showalter" wrote: >Schema: > >create table words (_id integer primary key autoincrement, wordtext >text not null unique); > >create table definitions (_id integer primary key autoincrement, >owningWordId integer not null unique, deftext text not null); >

Re: [sqlite] Raise is not working

2009-07-12 Thread Simon Slavin
On 13 Jul 2009, at 2:17am, Jim Showalter wrote: > However, calling insertOrThrow raises SQLiteConstraintException, which > does not contain the text of the raise specified in the schema. > Instead, it just has: > error code 19: constraint failed > > > > Is there any way to get SQLite to honor the

Re: [sqlite] Raise is not working

2009-07-12 Thread Jim Showalter
- Original Message - From: "Simon Slavin" To: "Jim Showalter" ; "General Discussion of SQLite Database" Sent: Sunday, July 12, 2009 7:44 PM Subject: Re: [sqlite] Raise is not working > > On 13 Jul 2009, at 2:17am, Jim Showalter wrote: > >> However

Re: [sqlite] Raise is not working

2009-07-12 Thread Jim Showalter
? - Original Message - From: "Jim Showalter" To: "General Discussion of SQLite Database" Sent: Sunday, July 12, 2009 6:10 PM Subject: Re: [sqlite] Raise is not working > Nevermind--for whatever reason, Google saw fit to do this: > >/** > * Convenience met

Re: [sqlite] Raise is not working

2009-07-12 Thread Jim Showalter
Log.e(TAG, "Error inserting " + values, e); return -1; } } - Original Message - From: "Jim Showalter" To: "General Discussion of SQLite Database" Sent: Sunday, July 12, 2009 6:03 PM Subject: [sqlite] Raise is not working > Schem

Re: [sqlite] Raise is not working

2009-07-12 Thread Jim Showalter
specific error code? Is Android swallowing raised exceptions and turning them all into just -1? - Original Message - From: "Jim Showalter" To: "General Discussion of SQLite Database" Sent: Sunday, July 12, 2009 6:03 PM Subject: [sqlite] Raise is not working > Schema:

[sqlite] Raise is not working

2009-07-12 Thread Jim Showalter
Schema: create table words (_id integer primary key autoincrement, wordtext text not null unique); create table definitions (_id integer primary key autoincrement, owningWordId integer not null unique, deftext text not null); create trigger fki_definitions_words_id before insert on definitions