[sqr-users] RE: Thinking about trying something - looking for ideas

[john.tucker@oracle.com]

Thanks for the suggestions, everyone.  I am working with data from a rather 
large (in number of tables) initial conversion, trying to make sure no one 
forgot a table, but I definitely agree with what everyone said about the 
perfect world.  It would be great, but it ain't gonna happen.

One of the suggestions mentioned building an array to go down the children - I 
actually have an SQR already that takes an input of a tablename and then tells 
you the parents all the way up the line and all of the children all the way 
down the line.  I thought about going with an array for that one, but ended up 
just writing several copies of the same select statement, going down to the 
next each time a child is found.  I believe that the deepest I was able to find 
was around 13 levels, so that's how many copies I included.  There are probably 
more elegant solutions, programming-wise, but it works well, so I haven't 
messed with it.

-John T.


_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users