To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=58184
Issue #:|58184
Summary:|Default value of zero causes the database to fail.
Component:|Database access
Version:|OOo 2.0
Platform:|All
URL:|
OS/Version:|Linux
Status:|NEW
Status whiteboard:|
Keywords:|
Resolution:|
Issue type:|DEFECT
Priority:|P3
Subcomponent:|none
Assigned to:|dbaneedsconfirm
Reported by:|pitonyak
------- Additional comments from [EMAIL PROTECTED] Sat Nov 19 17:53:14 -0800
2005 -------
I created a Base document with two tables; DEALER and ITEM. The tables are
simple:
DEALER Table
ID : INTEGER
NAME : VARCHAR
ITEM Table
ID : INTEGER
ITEM : VARCHAR
DEALER : INTEGER
The DEALER field in the ITEM table has a default value of zero.
The DEALER field in the ITEM table has a 1 to many relationship with the Dealer
ID.
I am able to create and use the table. When I reload the table, however, I
receive the following error:
The connection to the data source "OOoBaseAssociatedData" could not be
established.
error in script file line: 4 Column types do not matchmissing DEFAULT value on
column DEALER in statement [CREATE CACHED TABLE "ITEM"("id" INTEGER GENERATED BY
DEFAULT AS IDENTITY(START WITH 0) NOT NULL PRIMARY KEY, "ITEM" VARCHAR(50) NOT
NULL, "DEALER" INTEGER NOT NULL, CONSTRAINT SYS_FK_61 FOREIGN KEY("DEALER")
REFERENCES "DEALER"("ID") ON DELETE SET DEFAULT ON UPDATE CASCADE]
I have a document that describes the creation of these tables in depth.
I will attache the document, AND the Base file.
I receive the error message with the 139 DEV build. OOo version 2.0 just fails
on the document. The 140 DEV build will not even allow me to create a database,
so I am not even going to try with that version.
---------------------------------------------------------------------
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]
