on 03-29-2016 7:07 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
94 | |
11 | |
10 | |
6 | |
5 | |
5 | |
4 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.