i don't know a better way to phrase this, so let me illustrate in
pseudocode
stored_information # base table for stored info
id
useraccount_id
stuff
stored_information__name # extends stored info for name specific
stuff. essentially an 'inherits'
stored_information_id
name_specific_stuff
using rose, i need to get a list of stored_information__name for a
useraccount_id
i don't need / don't want the stored_information row
i'm hoping there's a way to either:
a) make a manager sub on stored_information, that will pull the
related info from stored_information__name and ignore the class info
for stored_information
b) make a manager sub on stored_information__name that uses a join
against stored_information, but does not retrieve the info in it
does that make sense at all? my db is normalized like this for some
performance reasons. i'd love to just not pull the data if at all
possible. though i think i'm going to be stuck with pulling an
entire row of [stored_information, stored_information__name]
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys -- and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Rose-db-object mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/rose-db-object