Variable value with Error Message

Ramco Ramco

1y688SQL

I am using Sap b1 Hana Database . I have below code . I want to display v_DpmBal value with error message . If i try like below i am getting error Invalid Number.

error_message:= 'Please select Down Payment Entries. Down Payment Balance : ' + v_DpmBal;

IF (:v_DpmBal  > 0 And :v_DpmAmnt = 0)
       THEN
	        error:= v_DpmBal;                          
  			error_message:= 'Please select Down Payment Entries. Down Payment Balance : ' ;
      END IF;

Thanks

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Amit Mohanty1y ago

Accepted answer

You can use the TO_NVARCHAR function to convert the numeric value to a string.

IF (:v_DpmBal > 0 AND :v_DpmAmnt = 0) THEN
    error := :v_DpmBal;
    error_message := 'Please select Down Payment Entries. Down Payment Balance : ' || TO_NVARCHAR(:v_DpmBal);
END IF;