[dba-issues] [Issue 78987] Can't insert records with NOT NULL fields with DEFAULT values
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=78987 User atjensen changed the following: What|Old value |New value Status|RESOLVED |CLOSED --- Additional comments from [EMAIL PROTECTED] Thu Jul 31 07:40:07 + 2008 --- tested w/ DEV200 m_28, XP closing - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 78987] Can't insert records with NOT NULL fields with DEFAULT values
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=78987 User mechtilde changed the following: What|Old value |New value Status whiteboard| |dba23b - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 78987] Can't insert records with NOT NULL fields with DEFAULT values
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=78987 User fs changed the following: What|Old value |New value Status|REOPENED |RESOLVED Resolution| |FIXED --- Additional comments from [EMAIL PROTECTED] Wed Aug 29 12:12:42 + 2007 --- resetting to FIXED this due to lack of feedback. fs-eeka1234: as said, we're somewhat short on time here, since we're in the hot phase of 2.3, and this issue is targeted for 2.3. I see the feasibility of a per-control setting for this, but for the moment, I'd say the original request - be able to insert into controls bound to required fields with server-side defaults - is fulfilled. This might not be the way you consider the optimal way, but please let's keep this out of this issue here. In other words: Please submit a new issue, requesting a per-control setting. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 78987] Can't insert records with NOT NULL fields with DEFAULT values
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=78987 User pjanik changed the following: What|Old value |New value CC|'eberlein,mechtilde' |'eberlein,fs,mechtilde' --- Additional comments from [EMAIL PROTECTED] Sun Aug 26 08:04:53 + 2007 --- fs: what is the status of this issue? Maybe a followup issue should be filed and this one closed again? - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 78987] Can't insert records with NOT NULL fields with DEFAULT values
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=78987 User pjanik changed the following: What|Old value |New value CC|'eberlein,fs,mechtilde' |'eberlein,fs,mechtilde,pja | |nik' - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 78987] Can't insert records with NOT NULL fields with DEFAULT values
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=78987 --- Additional comments from [EMAIL PROTECTED] Sun Aug 26 20:23:00 + 2007 --- fs-eeka1234: Do you agree opening a new issue for the per-control setting? This one here is targeted for 2.3, and we should get rid of it (or its current target) *fast*. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 78987] Can't insert records with NOT NULL fields with DEFAULT values
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=78987 User eeka1234 changed the following: What|Old value |New value Status|CLOSED|REOPENED Resolution|FIXED | --- Additional comments from [EMAIL PROTECTED] Fri Aug 24 00:21:35 + 2007 --- A per database or per form setting to address this issue is not ideal. If the software can't be made smart enough to figure out when a field is NOT NULL with a default value, it would be much better if the check could be disabled per field instead of per form or per database. It's perfectly reasonable for a database to have some fields that are specified as NOT NULL with a default value and have other fields which are specified as NOT NULL with no default value. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 78987] Can't insert records with NOT NULL fields with DEFAULT values
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=78987 User fs changed the following: What|Old value |New value Keywords|needmoreinfo, oooqa |oooqa --- Additional comments from [EMAIL PROTECTED] Wed Aug 22 08:23:52 + 2007 --- note: issue 80930 requests a user interface for this setting. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 78987] Can't insert records with NOT NULL fields with DEFAULT values
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=78987 User msc changed the following: What|Old value |New value Status|VERIFIED |CLOSED --- Additional comments from [EMAIL PROTECTED] Wed Aug 8 08:29:30 + 2007 --- Hi, this is fixed in the current master. The current master is available at http://download.openoffice.org/680/index.html I close this issue now. Bye Marc - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 78987] Can't insert records with NOT NULL fields with DEFAULT values
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=78987 User msc changed the following: What|Old value |New value Status|RESOLVED |VERIFIED --- Additional comments from [EMAIL PROTECTED] Wed Jul 18 09:49:37 + 2007 --- verified in CWS dba23b. find more information about this CWS, like when it is available in the master builds, in EIS, the Environment Information System: http://eis.services.openoffice.org/EIS2/cws.ShowCWS?Path=SRC680%2Fdba23b - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 78987] Can't insert records with NOT NULL fields with DEFAULT values
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=78987 --- Additional comments from [EMAIL PROTECTED] Thu Jul 12 21:09:36 + 2007 --- Okay, the proper macro is Dim oDataSource as Object oDataSource = createUnoService( com.sun.star.sdb.DatabaseContext ). _ getByName( ... ) Dim bValue as Boolean bValue = FALSE oDataSource.Settings.FormsCheckRequiredFields = bValue - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 78987] Can't insert records with NOT NULL fields with DEFAULT values
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=78987 User fs changed the following: What|Old value |New value Assigned to|fs|msc --- Additional comments from [EMAIL PROTECTED] Thu Jul 12 21:09:51 + 2007 --- fs- msc: please verify in CWS dba23b - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 78987] Can't insert records with NOT NULL fields with DEFAULT values
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=78987 User fs changed the following: What|Old value |New value Target milestone|OOo 2.x |OOo 2.3 --- Additional comments from [EMAIL PROTECTED] Thu Jul 12 21:15:51 + 2007 --- targeting to 2.3, since the fix is part of a CWS aiming for this release - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 78987] Can't insert records with NOT NULL fields with DEFAULT values
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=78987 --- Additional comments from [EMAIL PROTECTED] Sun Jul 8 13:03:18 + 2007 --- Just because I have easier access to MySQL than to PostgreSQL at the moment, for reproducing this with MySQL: - on a DB server of your choice, create a table with CREATE TABLE `server_default` ( `ID` Integer NOT NULL AUTO_INCREMENT PRIMARY KEY, `text` VARCHAR(50), `text_with_default` VARCHAR(50) NOT NULL DEFAULT 'default' ) - create a form for this table, containing input fields for all three columns - open this form for data entry - go to a new record - insert some value into the text field - try to save the record = an error message pops up saying that text_with_default requires an input, which is not true ... - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 78987] Can't insert records with NOT NULL fields with DEFAULT values
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=78987 --- Additional comments from [EMAIL PROTECTED] Sun Jul 8 19:48:29 + 2007 --- This is fixed in that it allows you to override the default behaviour (which is unchaned) on a per-database and a per-(logical-)form basis. That is, when an FormController (which is the instance raising the message box) is going to do the NULL but required checks, it beforehand checks it's logical form whether it has a property FormsCheckRequiredFields (more below). If this property is not present, the Settings of the DataSource which the form belongs to (more precise: which was used to create the connection of the form) is examined for this property. It is always present, and defaulted to TRUE. Well, leaving out some of the technical stuff: Dim bValue as Boolean bValue = FALSE oForm.addProperty( FormsCheckRequiredFields, 0, bValue ) will disable the checks per a logical form oForm. If you save the form document afterwards, the new property will be made persistent. Dim oDataSource as Object oDataSource = createUnoService( com.sun.star.sdb.DatabaseContext ). _ getByName( ... ) Dim bValue as Boolean bValue = FALSE oDataSource.Settings.setPropertyValue( FormsCheckRequiredFields, _ bValue ) will disable the checks for all forms for this database document. You still need to save the database document to make the setting persistent. (Note: The latter macro does not work :). I still need to investigate how to set boolean properties in Basic, the above will silently use a byte value for bValue, instead of a boolean one.) - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 78987] Can't insert records with NOT NULL fields with DEFAULT values
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=78987 User fs changed the following: What|Old value |New value Status|NEW |RESOLVED Resolution| |FIXED --- Additional comments from [EMAIL PROTECTED] Sun Jul 8 20:12:45 + 2007 --- fixed in CWS dba23b find more information about this CWS, like when it is available in the master builds, in EIS, the Environment Information System: http://eis.services.openoffice.org/EIS2/cws.ShowCWS?Path=SRC680%2Fdba23b - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 78987] Can't insert records with NOT NULL fields with DEFAULT values
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=78987 User eberlein changed the following: What|Old value |New value CC|'mechtilde' |'eberlein,mechtilde' - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 78987] Can't insert records with NOT NULL fields with DEFAULT values
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=78987 User mechtilde changed the following: What|Old value |New value CC|''|'mechtilde' Keywords| |needmoreinfo, oooqa --- Additional comments from [EMAIL PROTECTED] Fri Jun 29 07:47:15 + 2007 --- which connector do you use? - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 78987] Can't insert records with NOT NULL fields with DEFAULT values
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=78987 --- Additional comments from [EMAIL PROTECTED] Fri Jun 29 19:52:31 + 2007 --- This is Open Office 2.1 running on Windows XP with postgresql SDBC Driver 0.7.4 connecting to Postgres 8.2 running on Red Hat Enterprise Linux 5.0 - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 78987] Can't insert records with NOT NULL fields with DEFAULT values
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=78987 --- Additional comments from [EMAIL PROTECTED] Fri Jun 29 21:08:36 + 2007 --- *** Issue 76899 has been marked as a duplicate of this issue. *** - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 78987] Can't insert records with NOT NULL fields with DEFAULT values
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=78987 User fs changed the following: What|Old value |New value Assigned to|jbu |fs Ever confirmed| |1 Status|UNCONFIRMED |NEW Target milestone|--- |OOo 2.x --- Additional comments from [EMAIL PROTECTED] Fri Jun 29 21:09:33 + 2007 --- That's not an issue of the connection, it Base's GUI which has this, ehm, quasi-intelligence. Let's see what we can do about it. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 78987] Can't insert records with NOT NULL fields with DEFAULT values
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=78987 Issue #|78987 Summary|Can't insert records with NOT NULL fields with DEFAULT | values Component|Database access Version|OOo 2.2.1 Platform|All URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|jbu Reported by|eeka1234 --- Additional comments from [EMAIL PROTECTED] Fri Jun 29 01:29:21 + 2007 --- I have a field in PostgreSQL 8.2 of the type timestamptz with a Default Value of now() I also have the field set to NOT NULL This is the exact defintion: creation_timestamp timestamp with time zoneNOT NULLDEFAULT now(), I cannot create a form that will allow me to succesfully insert a record. I get this message: Error writing data to database Input required in field creation_timestamp. Please enter a value. I have experimented setting the control to Read-Only: Yes and Empty string is NULL: Yes, but I still get the error. If I remove the NOT NULL from the field's table definition, I can insert records as desired and the field is populated with now() on the server... but I would prefer to be able to keep the NOT NULL constraint. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]