Very Cool i didn't know the alias could be an expression!!
David David Blocker [EMAIL PROTECTED] 781-784-1919 Fax: 781-784-1860 Cell: 339-206-0261 ----- Original Message ----- From: "MikeB" <[EMAIL PROTECTED]> To: "RBASE-L Mailing List" <[email protected]> Sent: Monday, February 07, 2005 1:37 PM 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.... > > > > > > >
