on 12-20-2022 7:09 AM
Hello Experts,
I have made a query in which i defined specially for my exports customer only, if no zip code defines in customer details then in zip code value will be "999999".
But query runs for all customer as whether zip code is there or not..
So please tell me what value in query should I change to get my data done properly..
Below is the query :
IF @object_type = '23' and (@transaction_type IN ('A','U'))
begin
IF EXISTS(select * from OQUT
left outer join OCRD on OCRD.CardCode=OQUT.CardCode
left outer join CRD1 on CRD1.CardCode=OCRD.CardCode
where OQUT.DocEntry=@list_of_cols_val_tab_del and
OCRD.GroupCode=104 and CRD1.ZipCode <> '999999')
begin
set @error = '-14010'
set @error_message = 'Export Customer Zipcode should "999999".'
end
end
Regards
Malay Gandhi
Hi Malay,
Please try this:
IF @object_type = '23' and (@transaction_type IN ('A','U'))
begin
IF EXISTS(select *
from OQUT
inner join OCRD on OCRD.CardCode=OQUT.CardCode
inner join CRD1 on CRD1.CardCode=OCRD.CardCode
where OQUT.DocEntry=@list_of_cols_val_tab_del
and OCRD.GroupCode=104 and isnull(CRD1.ZipCode, '') <> '999999')
begin
set @error = '-14010'
set @error_message = 'Export Customer Zipcode should be "999999".'
end
end
Regards,
Johan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks sir..
It is working..
Regards
Malay
User | Count |
---|---|
109 | |
15 | |
10 | |
5 | |
4 | |
3 | |
3 | |
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.