Skip to Content
0
Former Member
Dec 20, 2022 at 07:09 AM

Query error

97 Views

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