----- Original Message ----- From: <[EMAIL PROTECTED]> To: "RBASE-L Mailing List" <[email protected]> Sent: Monday, February 07, 2005 1:14 PM Subject: [RBASE-L] - Re: SQL DATETIME vs R:BASE DATE
> Mike - > > Did you create an R:BASE table with a DATE column with the same name as the > SQL DATETIME column? Nope! But I will... > 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.... >

