To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=69243 Issue #|69243 Summary|SQL direct to usable for QiQ feature OOD680_m1 Component|Database access Version|OOo 2.0.3 Platform|All URL| OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|atjensen
------- Additional comments from [EMAIL PROTECTED] Mon Sep 4 09:00:51 -0700 2006 ------- With the new QiQ feature it is not possible to turn escape processing off if the query definiton uses another query definition. See the attached database. Open query2 in edit mode. Turn the dsigner window off, and the RUN SQL direct button on. The query generates an error from the database engine, as the query name passed as a table name is meanlingless to the engine. A suggestion, it would be a solution and I think helpful to users if when the SQL direct toolbutton is selected if the tex of the query defintion would reflect the actual select statment, after the replacement of query names with table names, be displayed. This change would be useful also for advanced users that may be experiencing unexpected results or errors when applying one of these QiQ defintions. --------------------------------------------------------------------- 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]
