Issue 47315

Summary:

copying the bugdoc dBase table into a HSQLDB fails

Product:

Base

Reporter:

Frank Schönheit <frank.schoenheit>

Component:

code

Assignee:

christoph.lukasiak

Status:

CLOSED FIXED

QA Contact:

issues@dba <issues>

Severity:

Trivial

Priority:

CC:

issues

Version:

680m92

Target Milestone:

OOo 2.4

Hardware:

OS:

Windows XP

Issue Type:

DEFECT

Latest Confirmation in:

---

Developer Difficulty:

---

Issue Depends on:

Issue Blocks:

20748

Attachments:

Description	Flags
document to reproduce the bug case	none

Description Frank Schönheit 2005-04-13 09:25:18 UTC

- create a dBase database document, pointing the to attached .dbf file
- open this database document, plus an arbitrary HSQLDB-based database
- drag'n'drop the table "invoices" from the dBase DB doc to the HSQLDB DB
=> the "Copy Table Wizard" opens up
- press "Create"
=> the table is copying, but there is an error message inbetween saying
   "Warning! An error occured. Do you want to continue copying?"

After examining the new table, it shows that two records are missing, where the
value in the Decimal column was greater than or equal to 10.

Comment 1 Frank Schönheit 2005-04-13 09:27:02 UTC

blocking meta issue

Comment 2 Frank Schönheit 2005-04-13 09:27:51 UTC

Created attachment 25010 [details]
document to reproduce the bug case

Comment 3 ocke.janssen 2007-08-30 13:17:26 UTC

Here the problem is that in dbase it was possible to enter data which isn't
valid for a decimal field. In this case decimal(3,2) and it was possible to
enter 18.00 which isn't valid in this case.
Fixed in cws dba24a

Comment 4 Frank Schönheit 2007-09-03 11:25:15 UTC

targeting to 2.4, since the fix is part of a CWS aiming for this release

Comment 5 ocke.janssen 2007-09-03 11:54:45 UTC

Please verify. Thanks.

Comment 6 christoph.lukasiak 2007-09-10 16:12:29 UTC

reopen -> still occure like described in cws

Comment 7 christoph.lukasiak 2007-09-10 16:13:50 UTC

back to dev

Comment 8 ocke.janssen 2007-09-19 11:50:33 UTC

The mistake here was that Base allows you enter data into a decimal field which
are invalid. The attached db contains such an invalid table. Please change the
values which are bigger than 10.

Comment 9 ocke.janssen 2007-09-19 11:50:54 UTC

Comment 10 christoph.lukasiak 2007-09-24 13:28:10 UTC

or set decimal field length to >3

verified in cws

Comment 11 drewjensen.inbox 2008-03-12 12:16:08 UTC

Tested  w/ OOo 2.4 m_10, Win Xp

closing