Peter Eberlein schrieb:
Hi Frank,
Frank Schönheit - Sun Microsystems Germany schrieb:
Hi Peter,
base forms have write access only if the underlying table has a
primary key.
Often this column has an autoincrement (HSQL and others).
In Oracle db's this must be realized with a trigger and a sequence.
It seems, that oo forms cannot handle this problem, because I get a
warning that the field with the primary field has to be filled out.
Any ideas how to handle this?
not really. Except you submit an issue requesting that Base does not do
those pre-checks, but relies on the DB server to return an error. The
Oracle case gives a good justification for this. I'd try to fix this for
2.3 then (but can't promise).
Ciao
Frank
filed http://www.openoffice.org/issues/show_bug.cgi?id=76899 for that.
Oh, just found the option Database/Extended Properties/Generated Values
where you have a checkbox for allowing generated values with an
autoincrement command.
May be, that's the solution but I didn't found time to dig into it until
now.
Regards
Peter
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
