Issue 18614 - copy table auto pilot: "Date/Time" fields in ADO are mapped to "Decimal" in dBase without any warning
Summary: copy table auto pilot: "Date/Time" fields in ADO are mapped to "Decimal" in d...
Status: CLOSED NOT_AN_OOO_ISSUE
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOo 1.1 RC3
Hardware: PC Windows 2000
: P3 Trivial (vote)
Target Milestone: OOo 2.0
Assignee: Frank Schönheit
QA Contact: issues@dba
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2003-08-25 09:10 UTC by Frank Schönheit
Modified: 2006-05-31 14:29 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description Frank Schönheit 2003-08-25 09:10:52 UTC 
* use an ADO/MDB data source, with a table containing a Date/Time field
* copy this table to a dBase data source (e.g. with Drag'n'Drop in the data
source browser)
=> in the dBase data source, the date/time column is created as "decimal"

This is quite confusing (especially since there is no warning at all). I
stumbled upon this because I, after the copy, tried to create a query based on
this table, and tried to apply a date criterion on the coluumn, which failed -
because it's no date column anymore.
Comment 1 Frank Schönheit 2003-08-25 09:11:04 UTC 
targeting
Comment 2 Frank Schönheit 2003-08-25 09:16:58 UTC 
oops, wrong target
Comment 3 ocke.janssen 2003-08-29 12:33:54 UTC 
This is correct, Access doesn't support a date type as dbase does.
They only have a datetime type which cannot mapped to a dbase type. So
the fallback is used, otherwise we would loose the hours,minutes and
seconds.
Comment 4 ocke.janssen 2003-08-29 12:34:15 UTC 
.
Comment 5 Frank Schönheit 2003-09-01 15:44:13 UTC 
submitted issue 18895 as follow-up. We definately have a usability
issue here, since the user does not remotely have a chance to know
what's going on.
Comment 6 Frank Schönheit 2003-09-01 15:44:43 UTC 
closing
Comment 7 hans_werner67 2004-02-02 12:17:38 UTC 
change subcomponent to 'none'