To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=77861 Issue #|77861 Summary|RPT: Crash on special report Component|Database access Version|current Platform|All URL| OS/Version|Windows XP Status|NEW Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P2 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|regina
------- Additional comments from [EMAIL PROTECTED] Sun May 27 22:53:06 +0000 2007 ------- Open the attached database document. Open report "Join" in edit mode. Goto report property. Make sure that in tab data the type SQL is choosen. It might be changed by document recovery. The SQL is: SELECT * FROM "Landessprache" AS "Landessprache" INNER JOIN "Länder" AS "Länder" ON "Landessprache"."Land" = "Länder"."Code" INNER JOIN "Sprachen" AS "Sprachen" ON "Landessprache"."Sprache"="Sprachen"."Kurz" Run that report. Crash. The same SQL statement works as query. Do not use the query design mode, because it changes INNER JOIN to WHERE. --------------------------------------------------------------------- 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]
