forms cannot handle Oracles mode of generated values

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

forms cannot handle Oracles mode of generated values

Peter Eberlein-3
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 input for required fields" of the
advanced settings and tried with a form (I left the pk field empty,
Oracle had to do this job):

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
inserted with the error message above again and again.

Then I deleted the pk control field, same error message.

If the form property "Analyze sql command" is set to false, all controls
are readOnly.

Regards


Peter


---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|

Re: forms cannot handle Oracles mode of generated values

Pavel Laštovička
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 work
either because OpenOffice did not know that the column should be
incremented automatically and one could not tell OO.o to do so. In my
database form that uses a grid control the grid's content was screwed up
after the "Exhausted resultset" error (e.g. content of one db row showed
in several grid rows).
   I use OO.o 3.1.1.

Regards
Pavel

Peter Eberlein napsal(a):

> 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 input for required fields" of the
> advanced settings and tried with a form (I left the pk field empty,
> Oracle had to do this job):
>
> 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
> inserted with the error message above again and again.
>
> Then I deleted the pk control field, same error message.
>
> If the form property "Analyze sql command" is set to false, all controls
> are readOnly.
>
> Regards
>
>
> Peter
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [hidden email]
> For additional commands, e-mail: [hidden email]
>
>


--
Pavel Laštovička, Developer & OpenOffice.org Specialist

blue.point Solutions, s. r. o.
tel: +420 412 510 182
fax: +420 412 510 182
Jabber: [hidden email]
http://www.blue-point.cz

IBM Business Partner - Novell Business Partner - Software602 Business
Partner

---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]

Reply | Threaded
Open this post in threaded view
|

Re: forms cannot handle Oracles mode of generated values

frank.schoenheit
In reply to this post by Peter Eberlein-3
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
> inserted with the error message above again and again.

submitted by you as issue 107812, confirmed and grabbed by /me, targeted
for 3.x ATM.

Ciao
Frank

--
- Frank Schönheit, Software Engineer         [hidden email] -
- Sun Microsystems                      http://www.sun.com/staroffice -
- OpenOffice.org Base                       http://dba.openoffice.org -
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

---------------------------------------------------------------------
To unsubscribe, e-mail: [hidden email]
For additional commands, e-mail: [hidden email]