Re: [dba-dev] forms cannot handle Oracles mode of generated values

2010-01-13 Thread Frank Schoenheit, Sun Microsystems Germany
Hi Peter, just for the record ... just tested with m7 and jdbc; Oracle handles the autogenerated values as following: ... After pushing Save the message comes: Exhausted resultset, but the record was inserted. But not enough: If the focus wants to left the form, a new record is

Re: [dba-dev] forms cannot handle Oracles mode of generated values

2009-12-15 Thread Pavel Lastovicka
Hello Peter, the same problem gave me a lot of headaches the last few days. I even thought that one week of work migrating my OO.o database to Oracle will be in vain. Moreover in database's anvanced properties there are some input fields relating to autoincrement column. This setting did not

[dba-dev] forms cannot handle Oracles mode of generated values

2009-12-14 Thread Peter Eberlein
Hi, just tested with m7 and jdbc; Oracle handles the autogenerated values as following: - You have to create a sequence which generates the value - You have to create a trigger before insert which reads the values of the sequence from the table dual. So done, I disabled Check form data