Re: [sqlite] problem with update trigger

"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' >

[sqlite] problem with update trigger

hello list, my problem is rather related to sql in general than to sqlite but as I'm using sqlite as my db and there are so many authorities of sql in this list I thought of asking my question here. I have the following schema: CREATE TABLE T_Linien( handle TEXT , von TEXT , nach