Apache OpenOffice (AOO) Bugzilla – Issue 60737
Default values in slave form broken for first row inserted
Last modified: 2007-04-03 17:15:04 UTC
In a slave form, defaulting doesn't work properly with first row that is automatically inserted when this is a column that has a dropdown based on a query. If this is marked "not null with default" in the database, then an error occurs once the first colmn value has been entered. When the master has a new row added the slave therefore has a first row automatically inserted. The default value is not populated in the column and hence an error results from the form validation. E.g. A non-nullable country column that has a dropdown based on a qry with the linked field being numeric (country code) and the displayed column in the dropdown a string (country name). Should be able to specify a default value that is automatically assigned when a new row is created. The "default selection" does not work with the first row. It works okay if you change it to nullable with default.
Do ease reproducing this issue, do you mind attaching a small sample database, with a sample form? That's far easier for every party which is later involved with this issue. Thanks for consideration.
Created attachment 33408 [details] Bzip2 compressed file of a plain text pg_dump for creating invoices database
Created attachment 33409 [details] Sample OObase showing bug. Form to open is "csutomerMaintenance". Requires "invoices" db (see previous attachment and bug comments)
I have attached two files - invoice.pgdump.txt.bz2 is a bzip2 file that should be uncompressed. The uncompressed file is a plain text dump for PostgreSQL 8.0.0 that can be used to recreate the "invoices" database so that you can use the OO2 Base docutment. OO2PGInvoiceDB.odb is the OO2 Base document with the form that shows the bug. The form name is "customerMaintenance". The create the invoices DB follow these steps on a machine which PostgreSQL 8.0.0 installated: create_db invoices psql invoices < invoice.pgdump.txt You may want to create a user and set the password for OO2 to connect to PG but depending on your setup, this may already be in place or may not be needed.
Same problem with Base + MySQL. http://www.oooforum.org/forum/viewtopic.phtml?t=30779
1. does the problem still occure in current version (is this issue still alive) 2. my you write a step by step description for better repro - i am not shure, that i do the same like you 3. may you attach a sample native (hsql) database for better repro (postgres & driver make a of lot trouble on my test machines) thx
set keyword 'needmoreinfo'
It certainly does! I will get a HSQL version of the DB for you to use.
clu -> kieser: is that issue still alive or does it work now?
no further respond -> seems to be fixed in between
do not hestitate to reopen this issue if it still occurs in a current version and you want to add a comment for better reproducebility thx