Issue 107812

Summary: base forms cannot handle Oracle's modus operandi for autogenerated values
Product: Base Reporter: eberlein <pet.ebe>
Component: codeAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: issues
Version: OOO320m8   
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---

Description eberlein 2009-12-21 13:26:12 UTC
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.
Comment 1 Frank Schönheit 2010-01-13 07:52:24 UTC
confirming, grabbing, targeting
Comment 2 Marcus 2017-05-20 10:47:37 UTC
Reset assigne to the default "issues@openoffice.apache.org".