To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=69243
------- Additional comments from [EMAIL PROTECTED] Tue Sep 5 04:43:03 -0700 2006 ------- "So allowing QiQ for native queries would be an ENHANCEMENT." That is not my point at all. What I am saying is that when the user selects 'Run SQl Direct' that the QiQ query definition be converted into the actual 'native' SQL statment that would have been sent to the engine if the 'Run SQL Direct' button where not engaged. So, in my example of Query1 : SELECT "abc".*, "level 1".* FROM "level 1", "abc" WHERE ( "level 1"."ID" = "abc"."ID" ) would become SELECT "Level 1".*, "ABC"* FROM "abc", ( SELECT * FROM "abc" ) AS "Level 1" WHERE ( "level 1"."ID" = "abc"."ID" ) There is already code to handle the transformation, it would just be a matter of runnig the query definition through this section and replacing the text of the query definiton with the out put. I realize that this would most likely need to be a one way trip so perhaps the user should be prompted before doing it. Or perhaps it could offer to do this 'into' a new query definition. There are two cases where it seems to me this would be a valuable feature. 1] The user wants to add some construct or funciton available with a specific database engine but not recognized by the OOo query parser, to an existing QiQ query definition. 2] Troubleshooting. For an example looking at Issue #69227, if one replaces the QiQ query definition Level 3, with the actual SQL statment that would be created by simple substitution and then pass this directly to the engine you get a completely different error then the one reported. [ Column already exists in Statement.... ] This error message actually gives someone enough information to let them fix the problem. --------------------------------------------------------------------- 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]
