Issue 66559

Summary:	allow parameters in native queries (HSQLDB)
Product:	Base	Reporter:	Frank Schönheit <frank.schoenheit>
Component:	code	Assignee:	AOO issues mailing list <issues>
Status:	ACCEPTED ---	QA Contact:
Severity:	Trivial
Priority:	P3	CC:	issues
Version:	680m172
Target Milestone:	---
Hardware:	All
OS:	All
Issue Type:	ENHANCEMENT	Latest Confirmation in:	---
Developer Difficulty:	---
Issue Depends on:
Issue Blocks:	69258

Description Frank Schönheit 2006-06-19 15:41:01 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.

Comment 1 Frank Schönheit 2006-06-19 15:41:28 UTC

accepting

Comment 2 Frank Schönheit 2006-08-06 21:30:31 UTC

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.

Comment 3 Frank Schönheit 2007-10-25 09:58:01 UTC

moving target

Comment 4 Frank Schönheit 2009-10-08 14:15:45 UTC

moving target milestone to something ... less unrealistic

Comment 5 Marcus 2017-05-20 10:47:57 UTC

Reset assigne to the default "issues@openoffice.apache.org".