Larry - This results in the error message, "Cannot convert a DATE value to a DATETIME value."
Sami -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Lawrence Lustig Sent: Monday, February 07, 2005 10:33 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: SQL DATETIME vs R:BASE DATE > I've tried to come up with a statement that this user could issue in his > R:BASE database to change the DATE column to DATETIME, but so far I haven't > been able to get the syntax worked out. ALTER TABLE TableName ALTER COLUMN ColumnName DATETIME This will not work if ColumnName is in more than one table, or if ColumnName IN TableName is indexed. -- Larry
