ck, Michael (IS)" <michael.bla...@ngc.com>
>To: General Discussion of SQLite Database <sqlite-users@sqlite.org>
>Sent: Tuesday, August 30, 2011 6:48 PM
>Subject: Re: [sqlite] Clarification about Triggers
>
>I found that if you used the default rowid it always gave -1 for the val
From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on
behalf of Dan Kennedy [danielk1...@gmail.com]
Sent: Wednesday, August 31, 2011 8:57 AM
To: sqlite-users@sqlite.org
Subject: EXT :Re: [sqlite] Clarification about Triggers
On 08/31/2011
On 08/31/2011 06:34 PM, Black, Michael (IS) wrote:
Doohyes "we" missed that. But shouldn't new.rowid be undefined then rather than return -1?
Much like old.rowid is undefined? That might have helped "us" in recognizing "our"
mistake.
Fair enough. Sounded pompous. I say "we" because I
tion Systems
Advanced Analytics Directorate
From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on
behalf of Dan Kennedy [danielk1...@gmail.com]
Sent: Wednesday, August 31, 2011 1:19 AM
To: sqlite-users@sqlite.org
Subject: EXT :Re: [sqlite] Clarification about Triggers
On 08/30/2011 10:48 PM, Black, Michael (IS) wrote:
I found that if you used the default rowid it always gave -1 for the value.
That's why I put in it's own key.
I don't understand why this doesn't work...perhaps somebody can point out the
error here...new.rowid contains -1. I would think that
value from a row of my choice.
From: Igor Tandetnik <itandet...@mvps.org>
To: sqlite-users@sqlite.org
Sent: Tuesday, August 30, 2011 3:18 PM
Subject: Re: [sqlite] Clarification about Triggers
stefanos sofroniou <stefanossofroniou...@yahoo.com> wrote
stefanos sofroniou wrote:
> Now what I want to do is to take two tables, (let's call them temp_01 and
> temp_02) that would both have columns id and val, and I
> want with a trigger to add temp_01.val with temp_02.val and put their result
> in a new table named
: Tuesday, August 30, 2011 9:42 AM
To: Black, Michael (IS)
Subject: EXT :Re: [sqlite] Clarification about Triggers
I did exactly what you have suggested but it does not work properly with my
software.
It increments my id (i replaced rownum with id, the function still is the
same), but the value
, August 30, 2011 2:32 AM
To: sqlite-users@sqlite.org
Subject: EXT :[sqlite] Clarification about Triggers
Hello everyone.
I have successfully created a trigger for experimentation and I would like your
help for implementing the concept behind of it.
My table pollaplasiasmos (which stands
Hello everyone.
I have successfully created a trigger for experimentation and I would like your
help for implementing the concept behind of it.
My table pollaplasiasmos (which stands for multiplication in Greek, even though
I used English characters to write it [Gree-glish]), takes 3 values:
10 matches
Mail list logo