thanks again !
I think I have to set this property for existing data by my self - in a loop
or so ... (so set to read only does not make sense)
as I am interested how cache realy works, here is an other problem I ran
into to find a work around about the class name:
the compiler says:
ERROR #5002: Cach�-Fehler: <FUNCTION> ???
GAS.ObjectReference.FromObject->ObjectType->Category = :Category AND
this does not seam to work ?
// x_classname = :ClassName AND
Query AllCateObjectRefRefListFieldNoType(ReferencedObject As %Integer,
Reference As %Integer, Field As %Integer, Category As %Integer, ClassName As
%String = "PlantStructure") As %SQLQuery(CONTAINID = 1)
{
SELECT GAS.Object.ID, GAS.Object.NameDe FROM GAS.Object, GAS.ObjectReference
WHERE (
GAS.Object.ID = GAS.ObjectReference.FromObject AND
GAS.ObjectReference.FromObject->ObjectType->Category = :Category AND
GAS.ObjectReference.ToObject = :ReferencedObject AND
GAS.ObjectReference.ObjectReferenceObject = :Reference AND
GAS.Object.Field = :Field AND
GAS.Object.ObjectType IS NULL
)
ORDER BY GAS.Object.NameDe
}
PS: will you join the symposium in june ?
brg
werner
"Florian Backes" <[EMAIL PROTECTED]> schrieb im Newsbeitrag
news:[EMAIL PROTECTED]
>
> > thanks a lot ... !
> >
> > perhaps you know also an answer to the following questions:
> >
> >>> and by the way how could I get some objects that are not contained
> >>> in a subclass
> >>> class type1
> >>> class type2 extents type1
> >>> class type3 extends type2
> >>> a query in type1 would deliver also type2 and type3 objects - that
> >>> is most times fine,
> >>> but is there a way to get only type1 objects (e.g. to check if there
> >>> are some of them to reassign them to sub classes) ?
> >
> >>I *think* there is a column "x_classname" which projects the specific
> >>class of an instance to SQL, you could use that...
> >
> >>Sorry about the uncertainties, Cach� SQL is not my main strength :(
>
> x__classname is the column name!
> Its a hidden column, but you can see it in the SQL Manager.
>
> x__classname is not indexed, so it may be very slow.
>
> Make your own property ClassName and set the initial expression
> to %ClassName(). Create a (bitmap)index on this property and you can
> access the data very fast.
>
> HTH
> Florian
