Skip to Content
avatar image
Former Member

Formatted search / Item Group

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Feb 23, 2004 at 04:40 PM

    You can see the result of you reference by opening the according query manually after you opened the form: $[$39.0.0] should be replaced with the desired value.

    I guess you're in the items management form?

    Then this is it: $[$39.1.0]

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 27, 2004 at 02:13 PM

    Thanks, Dierk

    It works now.

    Regards, Juha

    Add comment
    10|10000 characters needed characters exceeded