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]
