Cheryl At the R:>list col msdate Make sure all tables are the same for example you may have MSDATE in 1 table as computed and and another it may not be. I ran into this a few times.
Buddy -----Original Message----- From: McClure, Cheryl [mailto:[EMAIL PROTECTED]] Sent: Friday, November 02, 2001 10:26 AM To: Rbase-L (E-mail) Subject: Error message when saving table 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
