Re: [sqlite] Conditional triggers

[cscs-sqlite]

 
 
I sent this last night, but it didn't post on the list. Trying again to make
sure this is working.
       
       
------ Original Message ------
Received: 08:40 PM MDT, 08/27/2009
From: cscs-sql...@usa.net
To: General Discussion of SQLite Database <sqlite-users@sqlite.org>
Subject: Re: [sqlite] Conditional triggers
       
       
Yes, you should be able to do this but I think your conditions need to be:
       
when new.TypeID = 1
       
and
       
when new.TypeID = 2
       
I'm sure you saw this, but note the WHEN clause and text in the document
concerning when you can reference new and old values for the columns.
       
http://www.sqlite.org/lang_createtrigger.html
       
       
       
        ------ Original Message ------
        Received: 08:27 PM MDT, 08/27/2009
        From: Dennis Volodomanov <denn...@conceiva.com>
        To: "sqlite-users@sqlite.org" <sqlite-users@sqlite.org>
        Subject: [sqlite] Conditional triggers
       
       
       
       
        Hello all,
       
        Is it possible to create such an AFTER INSERT trigger
        that updates certain fields in a table based on the actual data being
        inserted?
       
        Let's say:
       
        CREATE TABLE abc(TypeID INTEGER)
        CREATE TABLE abcCount(TypeCountA, TypeCountB)
       
        CREATE TRIGGER CountTypeA AFTER INSERT ON abc /* when
        abc.TypeID == 1 */ BEGIN
        UPDATE abcCount SET TypeCountA=TypeCountA+1; END
       
        CREATE TRIGGER CountTypeB AFTER INSERT ON abc /* when
        abc.TypeID == 2 */ BEGIN
        UPDATE abcCount SET TypeCountB=TypeCountB+1; END
       
        Is something like that possible? I couldn't find any
        syntax construct I could put in place of the comment.
       
        Thanks in advance,
       
        Dennis
       
        _______________________________________________
        sqlite-users mailing list
        sqlite-users@sqlite.org
       
        http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
       
     
   
 


_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users