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: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org
--
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: pavel.lastovi...@blue-point.cz
http://www.blue-point.cz
IBM Business Partner - Novell Business Partner - Software602 Business
Partner
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscr...@dba.openoffice.org
For additional commands, e-mail: dev-h...@dba.openoffice.org