----- Original Message ----- From: "David M. Blocker" <[EMAIL PROTECTED]> To: "RBASE-L Mailing List" <[email protected]> Sent: Monday, February 07, 2005 2:49 PM Subject: [RBASE-L] - Re: SQL DATETIME vs R:BASE DATE
> Very Cool > > i didn't know the alias could be an expression!! I don't know of any place it's doc'd, but if you think about it, as long as it maps to the correct datatype it should work.. and it does. > 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.... > > > > > > > > > > > >
