Re: [sqlite] Clarification about Triggers

2011-09-16 Thread stefanos sofroniou
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

Re: [sqlite] Clarification about Triggers

2011-08-31 Thread Black, Michael (IS)
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

Re: [sqlite] Clarification about Triggers

2011-08-31 Thread Dan Kennedy
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

Re: [sqlite] Clarification about Triggers

2011-08-31 Thread Black, Michael (IS)
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

Re: [sqlite] Clarification about Triggers

2011-08-31 Thread Dan Kennedy
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

Re: [sqlite] Clarification about Triggers

2011-08-30 Thread stefanos sofroniou
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

Re: [sqlite] Clarification about Triggers

2011-08-30 Thread Igor Tandetnik
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

Re: [sqlite] Clarification about Triggers

2011-08-30 Thread Black, Michael (IS)
: 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

Re: [sqlite] Clarification about Triggers

2011-08-30 Thread Black, Michael (IS)
, 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

[sqlite] Clarification about Triggers

2011-08-30 Thread stefanos sofroniou
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: