To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=66559 Issue #:|66559 Summary:|allow parameters in native queries (HSQLDB) Component:|Database access Version:|680m172 Platform:|All URL:| OS/Version:|All Status:|NEW Status whiteboard:| Keywords:| Resolution:| Issue type:|ENHANCEMENT Priority:|P3 Subcomponent:|none Assigned to:|fs Reported by:|fs
------- Additional comments from [EMAIL PROTECTED] Mon Jun 19 07:41:01 -0700 2006 ------- Currently, when you switch on the "Run SQL Direct" option in the query designer (e.g. because you want to use SQL which OOo's own SQL parse does not yet understand), you cannot use parameters in those queries: For finding out which parameters a queries contains, it needs to parse them, so this isn't possible here. However, database backends themself are of course possible to parse all (valid) statements, and also to tell about the parameters therein. Since with HSQLDB, OOo Base ships a database engine which we have somewhat control over, we should investigate the possibilities to ask the HSQL engine for the parameters in an SQL statement. This way, we would be able to support parameters in "native" queries, too. --------------------------------------------------------------------- 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]
