I tried unloading the structure on the GOIMAST table per your suggestion.
The result of the reload was:
You must rename the non-computed column before you can do an UNLOAD
I have never seen that before.
Ed
Dec 19, 2009 12:55:51 PM, [email protected] wrote:
At 01:21 PM 12/19/2009, Ed Rivkin wrote:
>When I then try to alter the column in the remaining table,
>I am getting the following error messages which refer to a
>calculated field in the table.
>
>-ERROR- As column OpenDYear is used in another table, its
>type cannot be redefined. (2942)
>-ERROR- Unable to create/modify table. (2832)
Ed,
Relational Integrity is among the strengths of R:BASE!
Follow the steps as suggested by Emmitt and see where else
the same column name is used.
You may also UNLOAD STRUCTURE and then use R:BASE Editor
to search for the exact column name. This approach may
also be used to carefully search and replace any string
in a situation like yours.
Very Best R:egards,
Razzak.
