Re: Using views

From: Red Valsen <red_valsen@yahoo.com> > >What have been people's experiences using views? What are the pitfalls >in using them? Their worst limitations? Their best use? Or are they >such a maintenance nightmare that they shouldn't even be considered? >What guidelines would you advise in their use? I recently designed a solution to a massive internationalisation problem using views, and it seems to be working quite well. You just have to be aware of changes to base tables and their impact on the views, which is a largely manual exercise... ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com