Thanks, Mike - I'll pass that along... Sami -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of MikeB Sent: Monday, February 07, 2005 12:38 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: SQL DATETIME vs R:BASE DATE
This Works: cDateTime is DateTime in SqlServer and Date in RBASE.... sattach tdatatypes using cDateTime alias (DEXTRACT(cDateTime)) ----- Original Message ----- From: "MikeB" <[EMAIL PROTECTED]> To: "RBASE-L Mailing List" <[email protected]> Sent: Monday, February 07, 2005 1:25 PM Subject: [RBASE-L] - Re: SQL DATETIME vs R:BASE DATE > > ----- 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.... > > >
