To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=71951 Issue #|71951 Summary|SQL error when opening form with sub form (generated b |y Wizard) Component|Database access Version|OOo 2.0.4 Platform|PC URL| OS/Version|Linux Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P1 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|emilok
------- Additional comments from [EMAIL PROTECTED] Fri Nov 24 08:40:32 -0800 2006 ------- When opening a form (for viewing) with a super-sub-form relationship, created by the Form Wizard, the following SQL error is displayed: " SQL Status: 37000 Error code:-11 Unexpected token: : in statement [ SELECT * FROM "sub" WHERE (( "idSupSup" = :link_from_idSup)) AND (0 = 1) ] " *) The two tables are: "sup" and "sub". "sup" is the "main" form, and "sub" the sub form. *) A foreign key has been created using "Tools/Relationships..." *) The form, as mentioned, is crated using the Wizard. The table "sup" is first selected, and all its fields. Then "Add subform/Subform based on existing relation" is selected. Then "Finish" is pressed. TO REPRODUCE 1. Create a table "sup" with a single field "idSup" (INTEGER) which also is a primary key. 2. Create a table "sub" with two fields: "idSub" (INTEGER) is a PK, and "idSupSup" (INTEGER). 3. Use "Tools/Relationships..." to create a relation between the two tables, using the fields "sup.idSup" and "sub.idSupSup" (the options in the relationship creation dialog left unchanged). 4. Use the Form Wizard to create a form. 1. Choose "sup" as the table, select all fields. Press "Next". 2. Select "Add subform", "Subform based on existing relation" and select the table "sub". 3. Press "Finish". When the form shall be displayed for the first time, the error occurs. --------------------------------------------------------------------- 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]