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/
