Formatted search / Item Group

91 Views

Hi! We are trying to implement a two-level Item Group hierarchy in SBO 6.5.

For this purpose we created a User Table "@WQSITMGRPHIERARCHY") for linking each sub Item Group to top (parent) Item Group. The columns of this table (U_SubCode and U_TopCode, the type of both columns is Number 6) establish the links between Item Groups.

With Query Generator we created a Query (a SQL select) that we defined as formatted search for a new User Defined Field (type Alphanumeric 20) on the form.

It seems that we are not correctly getting the Item Group Code with references $[$39.0.0] or $[$OITM.ItmsGrpCod].

-

SELECT T2.ItmsGrpNam FROM "@WQSITMGRPHIERARCHY" T1, OITB T2 WHERE T1.U_TopCode = T2.ItmsGrpCod AND T1.U_SubCode = $[$39.0.0]

-

Pressing Shift-F2 in this field gives a blank field, Error 3006, or SBO "needs to close".

However, using a hard coded reference returns the correct Item Group Name:

-

SELECT T2.ItmsGrpNam FROM "@WQSITMGRPHIERARCHY" T1, OITB T2 WHERE T1.U_TopCode = T2.ItmsGrpCod AND T1.U_SubCode = '127'

-

Can you help us on this one?

Juha