Issue 70180

Summary:	Cannot change (UPDATE) memo / longvarchar fields
Product:	Base	Reporter:	andreschnabel <andre.schnabel>
Component:	code	Assignee:	marc.neumann
Status:	CLOSED FIXED	QA Contact:	issues@dba <issues>
Severity:	Trivial
Priority:	P2	CC:	issues
Version:	OOo 2.0.4	Keywords:	oooqa, regression
Target Milestone:	OOo 2.1
Hardware:	All
OS:	All
Issue Type:	DEFECT	Latest Confirmation in:	---
Developer Difficulty:	---

Description andreschnabel 2006-10-07 15:53:53 UTC

Values of Memo (longvarchar) fields cannot be changed in table (data) browser.

To reproduce:
- create a new base document (use default HSQLDB)
- create a new table with at least a primary key and a Memo field
- open the table for input
- enter some rows (key -  text for memo)
-> all is ok so far

- now try to change the values of any memo field
-> you can edit the fiel but the old value is restored on save (explicit save or
move to the next row)

* note: this happens only with HSQL databases (at least DBASE files are ok)

* possible workaround: create a form for the table - memo fields can be edited
in the form

Comment 1 christoph.lukasiak 2006-10-10 12:02:43 UTC

i can repro that like described

Comment 2 christoph.lukasiak 2006-10-10 12:04:01 UTC

raise prio because of the 'data lost'

Comment 3 christoph.lukasiak 2006-10-10 12:05:12 UTC

change owner

Comment 4 ocke.janssen 2006-10-23 09:10:16 UTC

Seems to be your area.
No updateX nor updateRow is called at the RowSet.

Comment 5 Frank Schönheit 2006-10-23 11:19:57 UTC

This is a regression of the CWS warnings01, caused by changes in the
[MultiLine]Edit class/es.

Comment 6 Frank Schönheit 2006-10-23 13:19:26 UTC

fixed in CWS dba21fini

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=SRC680%2Fdba21fini

Comment 7 Frank Schönheit 2006-10-30 13:49:01 UTC

fs-> msc: please verify in CWS dba21fini

Comment 8 marc.neumann 2006-11-01 09:35:02 UTC

verified in CWS dba21fini

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=SRC680%2Fdba21fini

Comment 9 drewjensen.inbox 2007-04-28 00:50:39 UTC

Test with OOo2.2 Stable, WinXP, Embedded HSQL database.