Skip to Content
0
Former Member
Oct 29, 2010 at 10:36 AM

HI all

15 Views

Hi all

What is the meaning of this error

Internal error (245) occurred .....

i call a query on a UDF .. query is ..

select Case LocCode When 1 Then 'Indo Arya Logistics,Hafed Complex,Wazirpur,Delhi-110034'

When 2 Then 'H-40,Bali Nagar,New Delhi-110015'

When 3 Then 'Khasra No.1194/3,1195/3 & 1712/1193/2/3(opposite Elegant & Maharaja factory) Behrampur Road,Village Khandsa,Distt.Gurgaon HR'

When 4 Then 'No.89,G.N.T.Road,Ponniamman Medu,Madhavaram,Chennai-600100,TamilNadu'

When 5 Then 'Sagar Heights Flat No:703-704,7th Floor Andheri Kurla Road,Sakinaka,Andheri(E)-400072,Telfax No.-022-28590675'

Else ' N/A ' End

from OPCH T0,PCH1 T1

where T0.DocEntry = T1.DocEntry

AND DocNum = N'manager'

AND DocType = 'S'

UNION

Select Distinct

(isnull(T0.WhsName,'') + ' - ' + isnull(T0.WhShipTo,'') + ' '+ isnull(T0.Street,'') + ' ' + isnull(T0.Block,'') + ' '+ isnull(T0.City,'') + '-' + isnull(T0.ZipCode,'') ) As Address

from OWHS T0,OLCT T1,OPCH T2,PCH1 T3

Where T0.Location = T1.Code

AND T2.DocEntry = T3.DocEntry

AND T3.WhsCode = T0.WhsCode

AND T2.DocNum = N'manager'

AND DocType = 'I'

..........................................................................................

query is working fine .....

But when i add aonther line like "When 6 Then 'ABCDEG... ??'

it gives the error

-

-


query after adding the line

-

-


select Case LocCode When 1 Then 'Indo Arya Logistics,Hafed Complex,Wazirpur,Delhi-110034'

When 2 Then 'H-40,Bali Nagar,New Delhi-110015'

When 3 Then 'Khasra No.1194/3,1195/3 & 1712/1193/2/3(opposite Elegant & Maharaja factory) Behrampur Road,Village Khandsa,Distt.Gurgaon HR'

When 4 Then 'No.89,G.N.T.Road,Ponniamman Medu,Madhavaram,Chennai-600100,TamilNadu'

When 5 Then 'Sagar Heights Flat No:703-704,7th Floor Andheri Kurla Road,Sakinaka,Andheri(E)-400072,Telfax No.-022-28590675'

When 6 Then 'ÁBCDEFGH'

Else ' N/A ' End

from OPCH T0,PCH1 T1

where T0.DocEntry = T1.DocEntry

AND DocNum = N'manager'

AND DocType = 'S'

UNION

Select Distinct

(isnull(T0.WhsName,'') + ' - ' + isnull(T0.WhShipTo,'') + ' '+ isnull(T0.Street,'') + ' ' + isnull(T0.Block,'') + ' '+ isnull(T0.City,'') + '-' + isnull(T0.ZipCode,'') ) As Address

from OWHS T0,OLCT T1,OPCH T2,PCH1 T3

Where T0.Location = T1.Code

AND T2.DocEntry = T3.DocEntry

AND T3.WhsCode = T0.WhsCode

AND T2.DocNum = N'manager'

AND DocType = 'I'

What is the meaning of this error (I Added a new whearehouse)/......