Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.
Bug 228611 - Improve handling of parameter markers in a SQB query text
Summary: Improve handling of parameter markers in a SQB query text
Status: RESOLVED FIXED
Alias: None
Product: z_Archived
Classification: Eclipse Foundation
Component: BIRT (show other bugs)
Version: 2.3.0   Edit
Hardware: PC Windows 2000
: P3 normal (vote)
Target Milestone: 2.3.0 RC0   Edit
Assignee: Linda Chan CLA
QA Contact:
URL:
Whiteboard:
Keywords:
Depends on: 228589 228599
Blocks:
  Show dependency tree
 
Reported: 2008-04-24 03:47 EDT by Linda Chan CLA
Modified: 2008-04-24 04:50 EDT (History)
0 users

See Also:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Linda Chan CLA 2008-04-24 03:47:58 EDT
In the DTP SQL Query Builder, an user can manually input a named parameter variable, and even use duplicated parameter variable names.  Thus the ODA runtime driver should be able to handle them by mapping named parameters to the corresponding parameter position.  At runtime, the named parameter variables in a prepared SQL text will be replaced by '?' parameter marker(s).
The custom ODA data set wizard page should be enhanced to process named parameter variables if any, plus obtain the parameter metadata available in the SQL Query model for its data set parameter design.
Comment 1 Linda Chan CLA 2008-04-24 04:50:43 EDT
Resolved.  Also updated the mapping of native data type codes supported by SQB.