Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.lang.clipper.visual-objects > #8158

Re: Vo2Ado DBTYPE_DBTIME2 (145)

Message-ID <556EB443.3060606@heliks.nl> (permalink)
Date 2015-06-03 10:01 +0200
Newsgroups comp.lang.clipper.visual-objects
From Robert van der Hulst <robert@heliks.nl>
Subject Re: Vo2Ado DBTYPE_DBTIME2 (145)
References <4dc5eb62-7e54-4043-8918-22da78c8abd1@googlegroups.com> <556D57B0.9060703@heliks.nl> <3ed2b786-b893-4b9b-9814-372ec4979512@googlegroups.com>

Show all headers | View raw


Veselin,

I am not sure why the type returns 145. That is not a valid value for 
the "DataTypeEnum".
(see 
https://msdn.microsoft.com/en-us/library/windows/desktop/ms675318%28v=vs.85%29.aspx)
This is probably the reason that you are getting errors.


Robert


> Robert,
>
> AdoField:Type returns 145 (which is correct for DBTYPE_DBTIME2), but AdoRecordset:FieldGet() or AdoRecordSet:GetRows() causes runtime error
>
> AdoErrors Class returns
>
> Provider = SAOLEDB.16
> Description = Multiple-step operation generated errors. Check each status value.
> SQLState = ''
> NativeError = 0
> SQLString = select f_date,t_datetime,t_time from dba._test
>
> t_time is a time data type field.
>
> As a workaround for now we changed SqlSelect ...string(t_time) as t_time, but if there is another solution would be better.
>
> Thanks
>
> Veselin
> .
>


-- 
Robert van der Hulst
robert@heliks.nl

Back to comp.lang.clipper.visual-objects | Previous | Next — Previous in thread | Find similar | Unroll thread


Thread

Vo2Ado DBTYPE_DBTIME2 (145) office.sonita@gmail.com - 2015-06-01 08:41 -0700
  Re: Vo2Ado DBTYPE_DBTIME2 (145) Robert van der Hulst <robert@heliks.nl> - 2015-06-02 09:13 +0200
    Re: Vo2Ado DBTYPE_DBTIME2 (145) office.sonita@gmail.com - 2015-06-02 07:31 -0700
      Re: Vo2Ado DBTYPE_DBTIME2 (145) Robert van der Hulst <robert@heliks.nl> - 2015-06-03 10:01 +0200

csiph-web