Alex, SELECT * FROM TABLE.Class WHERE %classname = "MyClass"
does not work in the SqlManager (Cache 5.05) ? Werner "Alexander Riemer" <[EMAIL PROTECTED]> schrieb im Newsbeitrag news:[EMAIL PROTECTED] > Werner, > > if you are on Cache 5.0.x try %classname > in your SQL Query > > Bye > Alex > > "Dipl.-Ing. Werner Riegler" <[EMAIL PROTECTED]> schrieb > im Newsbeitrag news:[EMAIL PROTECTED] > > Hi, > > > > I have some derived Classes and I wonder if I can use > > > > the .%ClassName() within my SQL Query...? > > > > > > There are some records in the result set from the child classes also - > > > > and I need a query that gives me only the toplevel objects of my selected > > class ... > > > > > > I must confess that at the moment I am not sure when an d why > > > > I get objects of child classes in my query also - and when not ... > > > > > > I have a CSP page to manipulate the common Properties of the toplevel > > class - > > and I thik this uses .%Save ... > > After using it - I get the objects in the toplevel and parent class query > as > > well as in the subclass query ... > > > > This is indeed a nice feature - but I need the toplevel and parent class > > objects without the subclass objects also !? > > > > So my idea is to use the %ClassName() in my query - > > and I found a "x__classname" as hidden column shown in the SQL manager - > > so I think there must be an easy way to do this - but how (didn't find > > anything in the docu?) ... > > > > > > brg > > Werner > > > > > > > > > >
