Class Qery with same Paramter Names and ->

[Dipl.-Ing. Werner Riegler]

Hi,

I need a query like:

 Query AllObjectRefRefListField(ReferencedObject As %Integer, Reference As
%Integer, Field As %Integer) As %SQLQuery(CONTAINID = 1)
{
SELECT GAS.Object.ID, GAS.Object.NameDe, GAS.Object.ObjectType->NameDe
    FROM GAS.Object, GAS.ObjectReference
    WHERE (
        GAS.Object.ID = GAS.ObjectReference.FromObject AND
        GAS.ObjectReference.ToObject = :ReferencedObject AND
        GAS.ObjectReference.ObjectReferenceObject = :Reference AND
        GAS.Object.Field = :Field
    )
    ORDER BY GAS.Object.ObjectType->NameDe, GAS.Object.NameDe
}

but the GAS.Object.NameDe and the GAS.Object.ObjectType->NameDe
does become mixed up ???

// FROM GAS.Object, GAS.ObjectReference
    IN ID, NameDe, Type ... does not work here

// %SQLQuery(CONTAINID = 1, ROWSPEC =
"ID:%Integer,NameDe:%String,ObjectType:%String" ... ???


brg
werner