Ignore my post about SQL. New info for me. Alexander is right.
Nuno
Alexander Riemer wrote:
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
