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