Query error

[Former Member]

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

[Johan_H · Accepted solution]

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

[Former Member · Accepted solution]

Thanks sir..

It is working..

Regards

Malay