Can any one please explain how loops are necessary in contexts, I read that loops are some times necessary based on the relationship between tables.
And that the loops are not always a problem
Thanks.
Teeta (BOB member since 2004-11-18)
Can any one please explain how loops are necessary in contexts, I read that loops are some times necessary based on the relationship between tables.
And that the loops are not always a problem
Thanks.
Teeta (BOB member since 2004-11-18)
It is the other way around. You typically use contexts to resolve the problem of loops in your universe. Unlike aliases, a context does not ‘break’ a loop, it simply provides a potential path between tables which may have a loop between them. As a general rule of good practice you need to resolve loops in your universe. You can, however, have loops within a context itself - this is not always a problem. Do you have a particular problem - concrete examples can clarify questions like this?
Nick Daniels (BOB member since 2002-08-15)
Keep in mind that even if the loop is necessary to create the correct results instead of creating a context for this loop I’d rather create a view (which joines the tables in a loop) and use that view in the universe. This makes universe maintenance easier IMHO.
Andreas (BOB member since 2002-06-20)
Nick,
This is the confusion i had while writting for this forum. I do not have particular example. but can you please explain me with an example how a loop within a context is not a problem
Teeta (BOB member since 2004-11-18)
Thats a good link that Andreas posted. If you don’t have this situation within a universe now, I wouldn’t get worked up about it until it happens.
Nick Daniels (BOB member since 2002-08-15)
Thank you Andreas and Nick.
I am designing a universe and wanted to think about this ahead.
That thread is exact.
Teeta (BOB member since 2004-11-18)
I find this forum very efficient and thousand powers of knowledge from various user.
This forum is a strict, efficient and professional one which benefits beginners like me.
Thanks a lot for the members who help me.
Teeta (BOB member since 2004-11-18)