To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=43528 Issue #:|43528 Summary:|Can't insert new field to place of choice in myql |tables with table edit Component:|Database access Version:|680m77 Platform:|PC URL:| OS/Version:|Linux Status:|NEW Status whiteboard:| Keywords:| Resolution:| Issue type:|DEFECT Priority:|P3 Subcomponent:|none Assigned to:|msc Reported by:|wurzel
------- Additional comments from [EMAIL PROTECTED] Fri Feb 25 01:54:49 -0800 2005 ------- Mysql db accessed via MyODBC 3.51.09 Open db document ODB. Click on the Tables button. Select the table in the table tree view. RMB click and choose Edit Table. Try to insert a new field into the table, of tinyint type, between the first field (int, autoincrement) and second field (varchar), using the RMB click on the leftmost column of the edit table view, where you can also delete and set the primary key and delete the field. The new field is systematically added to the end of the field list, and will also appear at that position when the table is opened for editing of the data. This means that the command "AFTER", "FIRST", or "LAST" in the SQL ALTER TABLE syntax are either not included in the function or are dropped on execution or are ignored. Reproducible every time. This is a regression compared to 1.1.4 and I remember was a problem during the 1.1 pre-release development. --------------------------------------------------------------------- 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]