All:

Within an RMD file, attempting to add a column to a table with a construct
which works in other contexts:

ALTER TABLE &vWDIncidentTotals_t  +
ADD COLUMN UnitCount INTEGER

I receive the error: 

"-ERROR- As column BuildingNUM is used in another table, its type cannot be
redefined. (2942)"

The existing table columns are: 'BuildingNUM' and 'IncidentCOUNT'.

'UnitCOUNT' is NOT a computed column. I'm not touching 'BuildingNUM'.

What's up?

Bruce


Reply via email to