Buddy - I don't know much about exactly how they are connecting - but they just moved their data from some other database into SQL and now they are having the problems. I did mention R:BASE Turbo 8.0 as an alternative to SQL.....
I'll make your suggestion, too. Thanks, Sami -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Walker, Buddy Sent: Monday, February 07, 2005 11:36 AM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: SQL DATETIME vs R:BASE DATE 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]
