To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=58184
------- Additional comments from [EMAIL PROTECTED] Sat Nov 19 18:26:51 -0800
2005 -------
I can FIX the Base document by manually editing the contained SCRIPT file (as
in, unzip the Base document, move to the Database directory, and edit the script
file, line 4) to read
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
DEFAULT 0 NOT NULL,CONSTRAINT SYS_FK_61 FOREIGN KEY("DEALER") REFERENCES
"DEALER"("ID") ON DELETE SET DEFAULT ON UPDATE CASCADE)
I added "DEFAULT 0" to the DEALER column in the ITEM table.
After this, I need to zip the directory structure back up again... Note that I
had been primarily using this document under the 139 dev build because I had
trouble creating this in the OOo version 2.0. On the other hand, the 139 dev
build has problems of its own :-(
---------------------------------------------------------------------
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]
