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


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

Re: Vo2Ado DBTYPE_DBTIME2 (145)

Path csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!feeder.erje.net!1.eu.feeder.erje.net!bcyclone04.am1.xlned.com!bcyclone04.am1.xlned.com!newsfeed.xs4all.nl!newsfeed2.news.xs4all.nl!xs4all!newsgate.cistron.nl!newsgate.news.xs4all.nl!post2.news.xs4all.nl!newszilla.xs4all.nl!not-for-mail
X-Spam-Checker-Version SpamAssassin 3.2.3 (2007-08-08) on HADES
X-Spam-Level
X-Spam-Status No, score=-3.6 required=6.3 tests=ALL_TRUSTED,AWL,BAYES_00 shortcircuit=no autolearn=ham version=3.2.3
Message-ID <556EB443.3060606@heliks.nl> (permalink)
Date Wed, 03 Jun 2015 10:01:07 +0200
Newsgroups comp.lang.clipper.visual-objects
From Robert van der Hulst <robert@heliks.nl>
Reply-To robert@heliks.nl
User-Agent Mozilla/5.0 (Windows NT 6.3; WOW64; rv:31.0) Gecko/20100101 Thunderbird/31.7.0
MIME-Version 1.0
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>
In-Reply-To <3ed2b786-b893-4b9b-9814-372ec4979512@googlegroups.com>
Content-Type text/plain; charset=windows-1252; format=flowed
Content-Transfer-Encoding 7bit
X-Hops 1
Lines 38
NNTP-Posting-Host 80.100.95.152
X-Trace 1433322905 dreader34.news.xs4all.nl 23284 80.100.95.152:63595
X-Received-Bytes 2162
X-Received-Body-CRC 902378614
Xref csiph.com comp.lang.clipper.visual-objects:8158

Show key headers only | 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