on 02-10-2014 5:38 AM
I want block null expiry date on OBTN through STPN.. Can anyone guide me on this.
Thanks & Regards
Hi,
Try this:
IF @transaction_type in ('A') AND (@OBJECT_TYPE='10000044')
BEGIN
If exists (SELECT t0.AbsEntry FROM OBTN T0 WHERE (T0.[ExpDate] IS NULL or T0.[ExpDate]=0) AND
t0.AbsEntry = @list_of_cols_val_tab_del)
Begin
SET @error = 1
SET @error_message = 'Please enter Expiry date'
End
End
Hope helpful.
Thanks & Regards,
Nagarajan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Try this...
IF (@object_type = '10000044') and (@transaction_type in ('A','U'))
BEGIN
IF EXISTS
(select AbsEntry FROM OBTN where ExpDate is null and AbsEntry = @list_of_cols_val_tab_del)
BEGIN
SET @error = 10
SET @error_message = N'Please Put Expiry Date First'
END END
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
86 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.