SQL IN

[Dipl.-Ing. Werner Riegler]

hi,

how could this work:

 Class GAS.ObjectType Extends GAS.NLSObject [ ClassType = persistent,
ProcedureBlock ]
{

 Property TypeTree As ObjectType [ Collection = list ];

 Query ObjectTypeChildList(ObjectType As %Integer) As %SQLQuery(CONTAINID =
1)
{
    SELECT GAS.ObjectType.ID, GAS.ObjectType.NameDe FROM GAS.ObjectType
    WHERE (
        :ObjectType IN GAS.ObjectType.TypeTree
    )
    ORDER BY GAS.ObjectType.NameDe
}

search in a collection - using sql IN ...  ???

brg

werner