Issue 87676 - [SQLite ODBC] pasted text in text box of data entry form repeats twice
Summary: [SQLite ODBC] pasted text in text box of data entry form repeats twice
Status: CLOSED IRREPRODUCIBLE
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOo 2.4.0
Hardware: All Windows Vista
: P3 Trivial (vote)
Target Milestone: ---
Assignee: issues@dba
QA Contact: issues@dba
URL:
Keywords: needhelp
: 86648 88316 (view as issue list)
Depends on:
Blocks:
 
Reported: 2008-04-01 02:21 UTC by gonzalez
Modified: 2009-07-12 19:34 UTC (History)
2 users (show)

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

Attachments
test case: SQLite3database (252.00 KB, application/vnd.sun.xml.base)
2008-04-15 21:03 UTC, gonzalez 		no flags Details
test case: .odb database (17.06 KB, application/vnd.sun.xml.base)
2008-04-15 21:03 UTC, gonzalez 		no flags Details
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 gonzalez 2008-04-01 02:21:29 UTC 
In OOo 2.4 Base (also in OOo DEV300 m3), if you paste a (copied) piece of text
in a text (box) data field of a data entry form,  the pasted text repeats twice
in the same field when the new record is saved (this does not happen when you
enter the same piece of text 
directly, without copying and pasting).
I did not have this problem in OOo 2.3.1 (working with the same database and MS
Vista).
Comment 1 gonzalez 2008-04-01 02:26:52 UTC 
P.S. Sorry I forgot this: the data base I am working with is sqlite 3 (ODBC).
Comment 2 gonzalez 2008-04-15 20:59:16 UTC 
The problem persists in all OOo-Dev300, including OOo-Dev300 m7.
I am attaching a copy of the SQLite3 database and the corresponding .odb
database, where the problem happens: if you paste a copied text in the text box
of the form (in this case, the form Notes_ProofDB_SQLite3_00001), this text
repeats twice after saving the record.
I find it a very nasty bug, because it often happens that you do need to past
text in your entry forms.
Comment 3 gonzalez 2008-04-15 21:03:01 UTC 
Created attachment 52838 [details]
test case: SQLite3database
Comment 4 gonzalez 2008-04-15 21:03:59 UTC 
Created attachment 52839 [details]
test case: .odb database
Comment 5 christoph.lukasiak 2008-05-05 13:44:05 UTC 
*** Issue 88316 has been marked as a duplicate of this issue. ***
Comment 6 christoph.lukasiak 2008-05-05 16:01:57 UTC 
*** Issue 86648 has been marked as a duplicate of this issue. ***
Comment 7 christoph.lukasiak 2008-06-18 15:26:09 UTC 
clu->all: can anyone who has an SQLite3 workplace confirm that please

thx
Comment 8 christoph.lukasiak 2008-09-24 12:46:51 UTC 
change owner
Comment 9 christoph.lukasiak 2008-09-24 12:48:24 UTC 
.
Comment 10 drewjensen.inbox 2009-07-12 05:10:32 UTC 
Using OO.o 3.1 was able to duplicate this using an ODBC driver under XP that was
a couple years old. Then updated to the 0.83 driver form
http://www.ch-werner.de/sqliteodbc/ and tried it again. The problem no longer
happens.

@gonzalez - if you are still having problems after the upgrade could you let us
know, otherwise I will go ahead and change this to Fixed(worksforme).
Comment 11 gonzalez 2009-07-12 13:10:13 UTC 
Fortunately, the forms are indeed working OK now. Many thanks.
Comment 12 drewjensen.inbox 2009-07-12 14:23:08 UTC 
Great - closing as worksforme
Comment 13 Mechtilde 2009-07-12 19:34:07 UTC 
worksforme -> closed