To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=60213 Issue #:|60213 Summary:|Cannot add records to tables without a primary key Component:|Database access Version:|OOo 2.0.1 Platform:|All URL:| OS/Version:|All Status:|UNCONFIRMED Status whiteboard:| Keywords:| Resolution:| Issue type:|DEFECT Priority:|P3 Subcomponent:|none Assigned to:|dbaneedsconfirm Reported by:|tony_52
------- Additional comments from [EMAIL PROTECTED] Sun Jan 8 07:57:19 -0800 2006 ------- I cannot add records to tables that do not have a primary key. This is true ofr the following. MySQL tables Oracle Tables Embedded HSQL tables This a defect, simply because a table does not have a primary key defined does not mean that it can't be edited, added to etc. There are many instances, that referential integrity is maintained within the application, not at the database level, this is true for locally developed databases, and third party supplied databases, by not being to add records to tables without primary keys, in many instances renders OpenOffice Base useless. At the moment I am finding it far quicker to develop applications using php combined with a web servers to achieve the results I should be able to achieve in minutes with OOBase, so not much chance of your average non-technical user accomplishing such a task. --------------------------------------------------------------------- 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]
