|
|
Posted by Jim Underwood on 10/02/52 11:45
Regarding this one point below...
If you always specify the column names then you will get an error instead of
getting bad data. It will take only a moment to add or remove a column from
your view to correct the error, which you will find immediately because the
code will not run.
It will take much longer to fix problems caused by bad data that is not
discovered for a month.
IMHO, you are much, much better off having the entire application stop
running while you fix a column name that you overlooked, rather than have
the application continue running and corrupt all of your data.
"Peter" <someone@someplace.com> wrote in message
news:2b3ef$44450c52$50394e09$1850@news.chello.nl...
> Maintenance drawback
> If the underlying table structure is changed: columns are added and
columns
> are deleted but the count of column keeps the same, I do not get a error
> message when I select the view and there is a change I get wrong results
> without noticing it in time.
>
>
Navigation:
[Reply to this message]
|