Cheryl -
Do a LIST COLUMN msdate
to find out if msdate has more than one definition. If it does then you
will have to rename one set of the versions to something else or drop the
tables containing those versions.
Bernie
At 10:25 AM 11/2/2001 -0500, you wrote:
>I'm updating a database design to work with ODBC (using R:BASE version 6.5++
>Windows Build: 1.842xRT03). I'm changing a column name from STD# to STDNUM.
>When I try to save the table I get the error message:
>
>-ERROR- As column MSDATE is used in another table, its type cannot be
>redefined. (2942)
>Unable to create/modify table.
>
>I am not changing MSDATE at all. MSDATE does exist in a couple of other
>tables, but it is defined in all tables as a DATE. What is happing here?
>How can I get around this problem?
>
>Thanks in advance.
>
>Cheryl
>
>
>
>
