Hi
In Issue for production i want mandatory field which i had created in title level
1 Process
2 issue to
3 Sub Contractor
i had written sp like this
IF @transaction_type IN (N'A', N'U') AND
(@Object_type = N'60')
begin
if exists (SELECT T0.[U_Process], T0.[U_Isst], T0.[U_KName] FROM OIGE T0
WHERE T0.[U_Process] is null or T0.[U_Isst] is null or T0.[U_KName] is null and T0.[DocNum]=@list_of_cols_val_tab_del)
begin
select @Error = 50 , @error_message = 'Please Fill PROCESS'
select @Error = 51 , @error_message = 'Please Fill Issue Type'
select @Error = 52 , @error_message = 'Please Fill Sub Contractor Name'
end
end
but i am not getting other two msgs
pls help
Ashish Gupte