Kbase P83569: SQL view does not show a new datatype for a field in MS Access
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
6/18/2004 |
|
Status: Unverified
SYMPTOM(s):
SQL view does not show a new datatype for a field in MS Access
CHANGE:
Datatype of a field was changed
CAUSE:
Both the SQL-92 standard and the SQL-99 standard say that
the view definition, and the definition of the columns in the view, is
defined by the "column descriptors" of the query expression defining the view.
And the standards say this creates a "view descriptor" in the db, meaning that the definitions are captured at time of creation. In other words, the definitions of the underlying base table columns, at time of view creation, define the view columns' datatypes (and other attributes).
And the standard itself does not define what happens if the datatype of
an existing base table is changed. That is, this capability is not in the
standard.
Progress SQL is standard compliant for view definitions and for the underlying base table changes.
FIX:
Drop the view, and then re-create the view.