Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.lang.clipper.visual-objects > #8158
| 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
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