Re: [sqlite] Which constraint is being violating??

2013-11-05 Thread Rafa de Miguel
Hello Alex, Didn't know that, very interesting, could be a good solution on my local machine but not for the final users of the app. I actually know which constraint is being violated, but I was thinking on build a standard message to warn the user on the save action based on the constraint

Re: [sqlite] Which constraint is being violating??

2013-11-04 Thread Alek Paunov
On 04.11.2013 11:46, Rafa de Miguel wrote: Yes, I knew that but that info it doesn't really help me too much FWIW: You probably are aware of this too, but just in case: On the browsers, especially these without build-in WebSQL (sqlite) support, the developer can fallback to a C to LLVM IR to

Re: [sqlite] Which constraint is being violating??

2013-11-04 Thread Rafa de Miguel
Yes, I knew that but that info it doesn't really help me too much El 04/11/13 10:33, Stephan Beal escribió: On Mon, Nov 4, 2013 at 10:26 AM, Rafa de Miguel < rafael.demig...@openbravo.com> wrote: Do I have control about the WebSQL version or it's Chrome whom decide it? FWIW: i don't know if

Re: [sqlite] Which constraint is being violating??

2013-11-04 Thread Stephan Beal
On Mon, Nov 4, 2013 at 10:26 AM, Rafa de Miguel < rafael.demig...@openbravo.com> wrote: > Do I have control about the WebSQL version or it's Chrome whom decide it? > FWIW: i don't know if this matters to you, but WebSQL was dropped from HTML5-related standardization efforts some time ago (2+ year

Re: [sqlite] Which constraint is being violating??

2013-11-04 Thread Rafa de Miguel
Thanks Clemens, I'm not sure how to do that. I'm using Google Chrome Version: 28.0.1500.52 which I think is the latest stable version. Do I have control about the WebSQL version or it's Chrome whom decide it? Thanks in advance, Rafa El 04/11/13 09:30, Clemens Ladisch escribió: Rafa de

Re: [sqlite] Which constraint is being violating??

2013-11-04 Thread Clemens Ladisch
Rafa de Miguel wrote: > Is there a way to know which constraint is being violated when you receive > the message constraint error 19: > > In example: my_column_name UNIQUE constraint Upgrade SQLite: sqlite> create table t(x unique); sqlite> insert into t values(1); sqlite> insert into t values(1

[sqlite] Which constraint is being violating??

2013-11-04 Thread Rafa de Miguel
Hello all, Is there a way to know which constraint is being violated when you receive the message constraint error 19: http://www.sqlite.org/c3ref/c_abort.html #define SQLITE_CONSTRAINT 19 /* Abort due to constraint violation */ In example: my_column_name UNIQUE constraint I'm using Web