To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=93056 Issue #|93056 Summary|When working with MySQL: query has to bes stored as vi |ew on server befor it can be loaded into another query Component|Database access Version|OOO300m3 Platform|Macintosh URL| OS/Version|Mac OS X Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P2 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|pancapangrawit
------- Additional comments from [EMAIL PROTECTED] Sat Aug 23 20:00:11 +0000 2008 ------- If you create a query and try to use this query in another query you will get an error saying that the 'table' does not exist, although it was possible to choose this query in the table-select dialog at query-design. Only when the source-query is stored as view on the server can it be used inside a base query. This might be necessary, but then it shouldn't be possible to load the source query through the standard dialogue. In this connection: it is not possible to rename a view stored on the server. That makes view-handling quite unpractical. --------------------------------------------------------------------- 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]
