Skip to Content
-1

transaction notification

May 06 at 06:24 AM

37

avatar image
Former Member

kindly find the below code that i want to prevent update on JE

Can any one help me

IF (:transaction_type = 'U' ) AND :object_type = '30' THEN

select distinct T0."TransId" , T0."Memo" FROM OJDT T0 INNER JOIN JDT1 T1 ON T1."TransId" = T0."TransId"

WHERE T0."TransId" = list_of_cols_val_tab_del;

error := -100;

error_message := N'You Cannot update remark on JE' ;

END if;

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Kennedy T May 08 at 05:47 AM
0

Try this

if @object_type ='30' and @transaction_type in ( 'U')    
   BEGIN

If Exists(
select distinct T0."TransId" , T0."Memo" FROM OJDT T0 INNER JOIN JDT1 T1 ON T1."TransId" = T0."TransId"

WHERE T0."TransId" = list_of_cols_val_tab_del
) 
Begin
                  
                                    SET @error = -2
                                    SET @error_message = 'You Cannot update remark on JE'
                              End
   
   END


Share
10 |10000 characters needed characters left characters exceeded