"Bernd Lehmkuhl" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > My goal is that 'von' always contains values that are smaller than > 'nach'. > > Unfortunately the update doesn't quite work as I expected it to do: > > UPDATE T_Linien > SET handle = '0815' > WHERE von = 'c' > AND nach = 'b' > AND objektartengruppe = 'xx'; > > SELECT * FROM T_Linien; > > handle von nach objektartengruppe > b c xx > > Isn't NEW.von 'c' and NEW.nach 'b' and shouldn't in that case exchange > the update trigger the two values?
The UPDATE trigger isn't called once per statement, but once for each row being updated. Since the WHERE clause in your statement doesn't match any rows, no update takes place and the trigger is never called. Igor Tandetnik _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
