To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=77635
User fs changed the following:
What |Old value |New value
================================================================================
Status|NEW |RESOLVED
--------------------------------------------------------------------------------
Resolution| |FIXED
--------------------------------------------------------------------------------
------- Additional comments from [EMAIL PROTECTED] Mon Jul 23 19:02:24 +0000
2007 -------
Okay, got the feedback ...
SELECT :PASS_IT FROM ... is invalid in that the DB engine is unable to determine
the type of the column before the parameter is actually filled with a value.
Later versions of HSQLDB will thus most probably reject this type of statement,
so there is no need to fix it for the moment.
The proper syntax would be SELECT CAST (:PASS_IT AS VARCHAR) FROM ...
Unfortunately, this is not recognized by OOo's parser, so there again would be
no parameter dialog.
Solutions:
1. Let Base use JDBC's facilities to obtain parameter meta data, even if OOo
itself cannot parse the statement. This is possible, but not yet implemented.
2. Let Base's parser recognize HSQL's CAST sytanx. There's not implementation
and no issue for this, yet. Volunteers?
For the moment, I set the issue to FIXED, since the original problem - no
parameter dialog appears -is fixed.
Fixed in CWS dba23c.
---------------------------------------------------------------------
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]
