Skip to Content
0
Former Member
Jul 04, 2009 at 11:38 AM

Mandatory Field

37 Views

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