To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=43528
------- Additional comments from [EMAIL PROTECTED] Sat Mar 5 01:02:33 -0800 2005 ------- Hi Frank, ooops, mea culpa, I've just tried it again with 1.1.4 and you're right. I was convinced that it had worked for me with 1.1.4. As it turns out, I've just had a very nasty surprise when trying this on 1.1.4, and shall probably file a bug issue for it (unless it has been corrected since then ;-)) I pick a table from a mysql db, enter the edit table mode and click on Insert a new line on the leftmost area. The field in front of which I insert the new line is shifted down and I can define my new field. So far so good. I define a field with a different column name to the subsequent field and make it varchar(3) for example. I get an error message from OOo : Error while connecting to data source [MySQL][ODBC 3.51 Driver][mysqld 4.0.20]Duplicate column name "assistant" Of course, the column "assistant" is the one I've just defined and doesn't exist elsewhere in the table. If I now close the table and say NO to saving the changes, when I open up the table again (I disconnect from the db and close OOo just to make sure everything is refreshed properly), the original field that was shunted downwards is now called "assistant" and the data present truncated to the length of the new defined field even though I didn't save the changes to the table. So now I have data loss for a change that I didn't even save :-(( new issue or not ? methinks yes. Alex --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
