Alex, no Error Message - neither in the SQL Manager nor in the Terminal - but just no results ...
it only works if I set the same Class in Table and in the WHERE clause ? Werner "Alexander Riemer" <[EMAIL PROTECTED]> schrieb im Newsbeitrag news:[EMAIL PROTECTED] > SELECT * FROM TABLE.Class WHERE %classname = "PackageName.MyClass" > > works for me. What error message do you get? > > Bye > Alex > > "Dipl.-Ing. Werner Riegler" <[EMAIL PROTECTED]> schrieb > im Newsbeitrag news:[EMAIL PROTECTED] > > 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 > > > > > > > > > > > > > > > > > > > > > > > > > > > >
