To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=107812 Issue #|107812 Summary|base forms cannot handle Oracle's modus operandi for a |utogenerated values Component|Database access Version|OOO320m8 Platform|All URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|eberlein
------- Additional comments from [email protected] Mon Dec 21 13:26:12 +0000 2009 ------- to reproduce: set up a oracle jdbc connection, "check form data input for required fields" is set to false. The table should at least contain one field (number, pk not null). Create in Oracle a sequence which generates the values. Create a trigger "before insert" which gets the generated values. Create a form in base with a primary key field. Insert a new record and leave the field empty. What should happen: record stored, finito. What happens: record stored, but message pops up "Exhausted resultset". No chance to leave the form with the cursor, new records are inserted until you make an update of the form and then refuse to store the new record. --------------------------------------------------------------------- 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]
