Your datawindow update properties are set to delete / insert, instead of
doing an update.
--
Terry Dykstra (TeamPS)
Canadian Forest Oil Ltd.
Violin wrote in message <371c6f7d.4832749_at_news.twsc.pouchen.com.tw>...
>Hello all,
>I have a very strange problem about trigger.
>In SQL*Plus,connect as scott/tiger and create the trigger:
>
>CREATE TRIGGER UPD_TEST
> BEFORE UPDATE
> ON EM_STOPPAY
> FOR EACH ROW
>BEGIN
> /* Just want to test */
> RAISE_APPLICATION_ERROR(-20002,'TEST');
>END UPD_TEST;
>/
>
>SQL> SELECT * FROM EM_STOPPAY;
>
>COMP FACT PNL_NO ST STOP_D HIRE_D REASON
>---- ---- -------- -- -------- -------- -----------------------------------
>A001 C001 559559 10 19990401 19990401
>A001 C001 010001 10 19990101 19990301
>A001 C001 559971 10 19990401
>
>SQL> UPDATE EM_STOPPAY SET STOP_D = '19990421'
> WHERE FACT_NO = 'C001' AND PNL_NO = '559971';
>
> UPDATE EM_STOPPAY SET STOP_D = '19990421'
> WHERE FACT_NO = 'C001' AND PNL_NO = '559971'
>
> ORA-20002: TEST
> ORA-06512: at "SCOTT.UPD_TEST" line 2.
> ORA-04088: error during execution of trigger 'SCOTT.UPD_TEST'
>
>
>BUT in Power Builder I connect as scott/tiger,too
>And then do the same update of em_stoppay,
>BUT the error message does not raise.
>It's so strange.I need some help.
>What's wrong with Power Builder??
>Please give me any suggestion and Thank you very much.
>
>Violin.
>violin.hsiao_at_mail.pouchen.com.tw
Received on Wed Apr 21 1999 - 09:59:00 CDT
