Skip to Content
0
Former Member
Jan 27, 2010 at 03:34 AM

Query Manager error

11 Views

Hello everybody.

I'm having a problem in creating a formatted search in UDF attached in BP Master Data

If i put this query on the manager:

SELECT A.[U_lupDesc] AS [BP Name]

FROM [dbo].[@SMC_BPTYPE] A

JOIN OCRG B

ON A.U_lupParent = B.GroupCode

WHERE B.GroupName = $[$16.0.1]

Im getting an "Internal Error" upon clicking the formatted search in BP Master Data

Note :

[dbo].[@SMC_BPTYPE] - created UDT

$[$16.0.1] - Group(item) in BP Master Data

Is this correct $[$16.0.1]? I was able to get this as $[$item.pane.variable].

Thnx in advance..