Hello, I'm always writing triggers and now I have the following problem:
For a table I have already written an insert and a delete trigger and now I'm testing the update trigger for the same table. The error message I get has the error number of the update trigger, but the shown values aren't of the update statement. Here is the example: Table t_arbumfang, Dbv_nr=1: std_arbumf=26 Table t_einsatz, Dbv_nr=1: std_einsatz=6 delete trigger: .... if std_arbumf<std_einsatz stop (4,'Std_Arbumf ( '&chr(std_arbumf)&' ) < Std_Einsatz ( '&chr(std_einsatz)' )') ... update trigger: .... if std_arbumf<std_einsatz stop (5,'Std_Arbumf ( '&chr(std_arbumf)&' ) < Std_Einsatz ( '&chr(std_einsatz)' )') ... Update statement: Update t_arbumfang set stunden=10 where Dbv_nr=1 The message I get is: ... 5 ,Std_Arbumf ( 0,00 ) < Std_Einsatz ( 6,00 )' When I look the values of this message I think an update of std_arbumf=10 is an delete (std_arbumf=0) plus an insert (std_arbumf=10) Is it right? How can I avoid the wrong and impossible delete? Can anybody help me? Thanks Ines _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
