Transaction notification

[Former Member]

i want to check a user defined filed in row  that it should not be blank while adding in sales order

can i get the row no and item code also in message

please help

[edy_simon]

Hi Nikhil,

SELECT @error = 999, @error_message = 'Row ' + CONVERT(NVARCHAR(10), VisOrder + 1 ) + '. Item Code = ' + ItemCode + '. UDF must not empty.'

FROM RDR1

WHERE DocEntry = @list_of_cols_val_tab_del AND ISNULL(U_FIELD,'') = ''

SELECT @error, @error_message

Regards

Edy