Issue 108038 - Appending tables with selected entries appends all records
Summary: Appending tables with selected entries appends all records
Status: CLOSED FIXED
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOO310m11
Hardware: PC Windows XP
: P3 Trivial with 1 vote (vote)
Target Milestone: OOo 3.3
Assignee: marc.neumann
QA Contact: issues@dba
URL:
Keywords: oooqa
Depends on:
Blocks:
 
Reported: 2010-01-03 00:35 UTC by beerhalter
Modified: 2017-05-20 10:24 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 beerhalter 2010-01-03 00:35:49 UTC 
Hi,
Drag&Dropping a selected set of DB-entries from table A and appending it to table B 
will append all (!) DB-entries of table A and not just the selected set. - This 
happens with Adabas-Tables as well as with MySQL-Tables - and maybe with other 
tables too.
Comment 1 r4zoli 2010-01-03 14:20:44 UTC 
Changed subcomponent to none.

@ beerhalter

Please describe step by step what you did, when problem happened.

You selected records from table A and tried to insert to Table B?
A and B table has a same structure?
They within same or different file, or connected to different server?
Comment 2 beerhalter 2010-01-03 22:33:12 UTC 
Tables A and B are from the same database on the same server (i.e., my PC) - the 
columns of B are a subset of A, but there are additional columns that are not to be 
transfered from A, i.e., an autoindex-filed IDX and a keyword-field MM. MM should 
be left blank to being filled in later by a keyword.

The problem is not the structure, but the fact that instead of the selected entries 
of A, all of the entries of A are being transferred to B.

Thanks for your looking into the problem.
Comment 3 marc.neumann 2010-01-04 13:31:06 UTC 
I can confirm this.

- select 2 records in the table view
- copy these 2 records with CTRL+C
- select a table in the main database windows  with the same structure
- select paste from the context menu of the table
- finish the wizard
==>> not only the selected records are pasted but all records of the table.
tested with OOO320_m8 and hsql database
Comment 4 ocke.janssen 2010-01-07 14:29:10 UTC 
Please take care for this. Thanks.
Comment 5 Frank Schönheit 2010-01-11 11:11:35 UTC 
fixed in CWS dba33f

find more information about this CWS, like when it is available in the master
builds, in EIS, the Environment Information System:
http://eis.services.openoffice.org/EIS2/cws.ShowCWS?Path=DEV300%2Fdba33f
Comment 6 Frank Schönheit 2010-01-11 11:15:27 UTC 
note that the selection is preserved as long as the source table data view is
opened. This is irrelevant for drag and drop, but when you copy the selection
into the clipboard, then the clipboard is emptied as soon as the table view is
closed.
Comment 7 beerhalter 2010-01-11 23:12:07 UTC 
Thank you for your efforts. - Hans B.
Comment 8 Frank Schönheit 2010-03-15 14:10:11 UTC 
targeting to 3.3, since the fix is part of a CWS which aims for this release
Comment 9 Frank Schönheit 2010-04-19 20:21:26 UTC 
fs->msc: please verify in CWS dba33f
Comment 10 marc.neumann 2010-05-26 14:45:01 UTC 
verified in CWS dba33f

find more information about this CWS, like when it is available in the master
builds, in EIS, the Environment Information System:
http://eis.services.openoffice.org/EIS2/cws.ShowCWS?Path=DEV300%2Fdba33f