To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=94790
Issue #|94790
Summary|can't save record with null/default value field until
|changing it
Component|Database access
Version|OOo 2.4.1
Platform|PC
URL|
OS/Version|Linux
Status|UNCONFIRMED
Status whiteboard|
Keywords|
Resolution|
Issue type|DEFECT
Priority|P3
Subcomponent|none
Assigned to|dbaneedsconfirm
Reported by|molibdeno
------- Additional comments from [EMAIL PROTECTED] Thu Oct 9 04:25:08 +0000
2008 -------
Given the following table:
CREATE CACHED TABLE "Table1"("number" INTEGER GENERATED BY DEFAULT AS
IDENTITY(START WITH 0) NOT NULL PRIMARY KEY,"y/n" BOOLEAN)
Opening "Table1" (right click > open, or double click, or Edit menu > Open
database object...)
you can't save the record until you change the value of the boolean field,
doesn't matters what the default value is set to.
The same happens with the following one when the value of the field "name" is
null:
CREATE CACHED TABLE "Table6"("num1" INTEGER GENERATED BY DEFAULT AS
IDENTITY(START WITH 0) NOT NULL PRIMARY KEY,"name" VARCHAR(100))
You can't save the record until you change the value of the "name" field. You
can for example add a character and then erase it leaving the field as before,
but now you will be able to save the record. This will not happen if you set a
default value for "name" explicitly.
The same happens with tables with more than 2 fields, as long as the primary key
is an INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 0) NOT NULL PRIMARY
KEY (doesn't matters if it is the first, or any other field), and the rest of
the field values are left null (if there is any boolean its value is the
default). Now you only need to change one of the non primary key fields to be
able to save the record.
---------------------------------------------------------------------
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]
