TRRIGER

[reemy]

HI ALL
I HAVE TABLE XX WITH FIELDS ID , X , CREATOR , CREATED AND I HAVE BUILD THE FOLLOWING TRRIGER ON IT :

CREATE OR REPLACE TRIGGER BUG.YY
BEFORE INSERT
ON BUG.BUGS_REPLIES
REFERENCING NEW AS NEW OLD AS OLD
FOR EACH ROW
DECLARE
tmpVar NUMBER;

BEGIN tmpVar := 0;
SELECT BUGS_REPLIES_ID_SEQ.NEXTVAL INTO tmpVar FROM dual; :NEW.ID := tmpVar;
:NEW.creator := USER;
:NEW.created := SYSDATE;

EXCEPTION
WHEN OTHERS THEN
-- Consider logging the error and then re-raise
RAISE;
END ;

THEN I BUILD FORM ON THAT TABLE AND AFTER I PRESS COMMIT KEY AND TRY TO UPDATE THE X FIELD THE FORM UNALBE TO LET ME TO DO CHANGE ON THAT FIELD ERROR MESSAGE APPEAR SAY THAT RECORD IS UPDATE BY ANTHOR USER CAN ANY ONE HELP ME ON THAT ?

[عبدالله ندا]

if u use  oracle 8i then  set block property 
dml returning value = yes 
update changed columns only = yes 
but the second will fail if yeu use  
if updating ... or  if inserting or .... if deleting  
in ur data base trigger 

if u still have proplem then 
in key-commet  after commit  requery the database 
B.R.

[reemy]

Thanks so much it's work successfully
جزاك الله خيراً