SQL with Parameters [message #1772441] |
Sat, 09 September 2017 21:21 |
Dave Paulson Messages: 7 Registered: September 2017 |
Junior Member |
|
|
I'm new to BIRT, so please excuse my naivete. I'm working on a BIRT report that uses report parameters at runtime. These are linked to the appropriate dataset parameters, but the report fails with an error message that suggests the parameters are not effectively passing to the actual SQL query.
Is there a way to see the actual query string passed to the server? I tried setting the logging level to FINEST, and even though this logs the query, it doesn't appear to log the value of the parameters. After running the nonworking report and finding the "?" markers still in the string, I ran a report that works without error, and it too showed the markers and not the runtime values.
Any help would be appreciated.
Thanks,
Dave
[Updated on: Tue, 12 September 2017 18:34] Report message to a moderator
|
|
|
|
|
|
|
|
Powered by
FUDForum. Page generated in 0.03683 seconds