My oterro.cfg and rbase.cfg are exact copies of each other, with only the
name value being different.
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
> Behalf Of A. Razzak Memon
> Sent: Thursday, August 23, 2001 9:01 AM
> To: [EMAIL PROTECTED]
> Subject: RE: Oterro and Time Field - Razzak's Reply
>
>
> Eric,
>
> I would also check the DATE and TIME SETtings in
> OTERRO.CFG!
>
> Among many other SETtings, DATE and TIME SETtings in
> OTERRO
> SHOULD match the DATE and TIME SETtings in RBASE.CFG
> file.
>
> Very Best Regards,
>
> Razzak.
>
>
> At 08:03 AM 8/23/2001 -0500, Crued @ Crued.net wrote:
>
> >straight out of the recordset. select from r> will
> list
> >proper value, ottero will not list proper value. date
>
> >field *will* list just a date, but time field will
> list
> >date and time.
>
>
> >
> >
> >> -----Original Message-----
> >> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On
> >> Behalf Of Dennis McGrath
> >> Sent: Thursday, August 23, 2001 7:29 AM
> >> To: [EMAIL PROTECTED]
> >> Subject: RE: Oterro and Time Field
> >>
> >>
> >> Very strange. Are you sure VB is not doing a
> translation? Use the
> >> immediate
> >> window and display the value right out of the
> recordset. That
> >> will tell you
> >> more about what Oterro is actually retreiving.
> >>
> >> -- Dennis McGrath
> >> mailto:[EMAIL PROTECTED]
> >>
> >> -- Tools for R:BASE programmers
> >> http://www.enteract.com/~mcgrath/dennis
> >>
> >> -- Full time consultant with SQL Resources
> >> mailto:[EMAIL PROTECTED]
> >>
> >> -----Original Message-----
> >> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On
> >> Behalf Of Ron Rose
> >> Sent: Wednesday, August 22, 2001 5:53 PM
> >> To: [EMAIL PROTECTED]
> >> Subject: Re: Oterro and Time Field
> >>
> >>
> >> SET VAR vtextract = (TEXTRACT(.vdatetime))
> >> returns the TIME portion.
> >> RRR
> >>
> >> "Crued @ Crued.net" wrote:
> >> >
> >> > I have a field in my DB defined as TIME. When I
> retrieve the
> >> field using
> >> > Oterro (w/ ADO 2.7), instead of getting just a
> time like '09:00', I get
> >> the
> >> > current date along with the time '08/22/2001
> 09:00'. Anybody have any
> >> > ideas?
> >> >
> >> > Thanks,
> >> > Eric
>
>
> __________________________________________________
> Do You Yahoo!?
> Make international calls for as low as $.04/minute with Yahoo! Messenger
> http://phonecard.yahoo.com/
