>I can narrow it down to 60 or so updatable fields, but does that do much? The only difference would be changing the statements to false, but it wouldn't shorten it. Or am I missing what you are getting at here?
>
>Borislav, I'm a bit confused. Setting up this view like so has fixed my earlier problem, though given me a new one. Therefore, couldn't it be used productively? Or do you mean it is too much for what I am trying to do?
Ron,
Views are usually used to limit data by some criteria. Also to limit the data fields from the original table. In your case you're trying to bring the whole table over, so there is no point of using it as a view, you can just table buffer your table instead. The only benefit of using view in this case would be potential upsizing in a future...
If it's not broken, fix it until it is.
My Blog