Apache OpenOffice (AOO) Bugzilla – Issue 66559
allow parameters in native queries (HSQLDB)
Last modified: 2017-05-20 10:47:57 UTC
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.
accepting
HSQLDB already supports ParameterMetaData at a prepared statement (http://java.sun.com/j2se/1.5.0/docs/api/java/sql/ParameterMetaData.html), but for the purpose of OOo, it would be convenient to have more information. In particular, parameter names would be interesting.
moving target
moving target milestone to something ... less unrealistic
Reset assigne to the default "issues@openoffice.apache.org".