To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=106181 Issue #|106181 Summary|[cws hsqldb19] Database conversion makes subform grid |unusable Component|Database access Version|DEV300m61 Platform|Unknown URL| OS/Version|Windows XP Status|NEW Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|r4zoli
------- Additional comments from r4z...@openoffice.org Thu Oct 22 09:30:27 +0000 2009 ------- I converted Drew's example file from forum: http://user.services.openoffice.org/en/forum/download/file.php?id=649 This file use middle table with combined PK to simulate many-to-many relationship. Before conversion the "Movies" form with subform and grid on it works. After conversion the grid on subform, stopped working. Only change is conversion to new database format. If I compare two script, only difference among others which connected to other conversation, the CONSTRAINT SYS_FK_XXs removed: 1.8 version: CREATE CACHED TABLE "MovieGenre"("MovieID" INTEGER NOT NULL,"GenreID" INTEGER NOT NULL,PRIMARY KEY("MovieID","GenreID"),CONSTRAINT SYS_FK_67 FOREIGN KEY("MovieID") REFERENCES "Movie"("MovieID"),CONSTRAINT SYS_FK_70 FOREIGN KEY("GenreID") REFERENCES "Genre"("GenreID")) 1.9 version: CREATE CACHED TABLE PUBLIC."MovieGenre"("MovieID" INTEGER NOT NULL,"GenreID" INTEGER NOT NULL,PRIMARY KEY("MovieID","GenreID"),FOREIGN KEY("MovieID") REFERENCES PUBLIC."Movie"("MovieID"),FOREIGN KEY("GenreID") REFERENCES PUBLIC."Genre"("GenreID")) --------------------------------------------------------------------- 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: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org --------------------------------------------------------------------- To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org