Mike - Did you create an R:BASE table with a DATE column with the same name as the SQL DATETIME column?
Sami -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of MikeB Sent: Monday, February 07, 2005 12:10 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: SQL DATETIME vs R:BASE DATE > 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. Sami, I set up a test table with a datetime column in SqlServer 2000. Both Rb7 and Rb65 SConnect and SAttach to the database and table without error and I can browse the single line of data in the table without error.. It is going to be very difficult to address this guys problem without seeing his code etc....
