To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=69258 Issue #|69258 Summary|SQL query not working as subform Component|Database access Version|OOo 2.0.3 Platform|Macintosh URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|fbrzvnrnd
------- Additional comments from [EMAIL PROTECTED] Tue Sep 5 00:06:17 -0700 2006 ------- If I build a query using SQL, and I want to use the query as subform, the link between the form and the subform is not working if I use the SQL button to use the query as SQL (the subform makes everytime a complete query and shows all the fields). Look at the example file: selecting datas in form, the subform do not shows datas and in the form properties I do not see column name of the SQL query. The query is working fine in subform if I do not check the SQL icon in toolbar, but I can not do this, 'cause -if I do no check the SQL icon- when I close the query and I need to reopen it to modify it, openoffice opens the query in design graphic mode. If the query I wrote in SQL (and working in form!) is quite complex the desing mode destroy the query and do not give me the choose to exit the design mode for a generic SQL syntax error. --------------------------------------------------------------------- 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]
