Issue 14433 - Parameter in SQL statements don't work
Summary: Parameter in SQL statements don't work
Status: CLOSED IRREPRODUCIBLE
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOo 1.0.3
Hardware: PC Linux, all
: P1 (highest) Trivial (vote)
Target Milestone: ---
Assignee: Frank Schönheit
QA Contact: issues@dba
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2003-05-14 10:07 UTC by tb
Modified: 2006-05-31 14:29 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description tb 2003-05-14 10:07:08 UTC 
Hi,

if I use a parameter in a SQL statement in the form:

select * from PART where PART_ID=:x

throws OO an exception:

Java: ArrayIndexOutOfBoundsException
unixODBC: Invalid Decriptor Index (SQL-Code: 7009)

Tested with MySQL:
RDBMS: 3.23.49
JDBC: 2.0.8
ODBC: 3.50.39

The visualisation of 1:n relations via subform are not possible.

Bye Thomas
Comment 1 marc.neumann 2003-05-14 10:45:21 UTC 
Hi Thomas,

please see

http://dba.openoffice.org/howto/param_subst.html

for the solution.

Thanks and bye
Marc
Comment 2 marc.neumann 2003-05-14 10:46:13 UTC 
I close this bug. Feel free to reopen it, if the above solution not
solve your problem.

Bye Marc
Comment 3 hans_werner67 2004-02-02 12:59:51 UTC 
change subcomponent to 'none'