Re: Recursive join - blind alley?

From: Mike MacSween <mike.macsween.nospam_at_btinternet.com>
Date: Sat, 3 Jan 2004 12:50:54 -0000
Message-ID: <3ff6baae$0$52886$5a6aecb4@news.aaisp.net.uk>

Fletcher

Thanks. I wasn't dismissing your codes out of hand. I appreciate the advice. As a matter of fact right now I'm looking at materialised paths. This http://fungus.teststation.com/~jon/treehandling/TreeHandling.htm in particular looks interesting. But I repeat I've only just come across this. Though your codes look a little bit like materialised paths (and that's a very top of the head comment!).

Yes, I usually work the way you suggest. Come up with a fairly abstract ER/CDM model (or one corner of it). Then quickly knock up some nonsense tables in Access to see if/how well it works. Missing out the weeks of correct relational modelling and such.

Cheers, Mike Received on Sat Jan 03 2004 - 06:50:54 CST