Sami Did you try using the ALIAS the column names when using the SATTACH.
SATTACH SQLTableName USING RbaseTableName ALIAS ,,,,NewColName,,,, I had to use this method when attaching to an SQL database that had different datatypes in different tables with the same column name. Buddy -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED] Sent: Monday, February 07, 2005 11:29 AM To: RBASE-L Mailing List Subject: [RBASE-L] - SQL DATETIME vs R:BASE DATE I've received a post from a 6.5+ user who is doing SATTACH to a MS SQL Server database. The R:BASE database has a DATE column, but in the SQL database, it's a DATETIME column and returns the error, Error - Cannot attach DATETIME column type <COLUMNNAME> to column type of 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. Any help would be appreciated, Thanks, Sami ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Sami Aaron Software Management Specialists 913-915-1971 [EMAIL PROTECTED]
