Eclipse Community Forums: BIRT » Trapping Dataset Exception errors

Help

Home

Home » Archived » BIRT » Trapping Dataset Exception errors(Trapping Dataset Exception errors)

Show: Today's Messages :: Show Polls :: Message Navigator

Trapping Dataset Exception errors [message #1403717]

Fri, 25 July 2014 14:14

Keith Clark

Messages: 11
Registered: July 2014

Junior Member

I have a situation where I need to preload a table of a database with values selected from a multiple select report parameter.

I have been able to successfully use the beforeOpen event handler of the dataset to modify the sql to write these values.

Problem that I get is the fact that since its an insert command, there is not result set, and the dataset throws an exception and stops.

Is there a way to trap the exception, or hide it and continue the report?

Report message to a moderator

Re: Trapping Dataset Exceptio n errors [message #1403761 is a reply to message #1403717]

Sat, 26 July 2014 09:04

Colin Sutton

Messages: 121
Registered: July 2009

Senior Member

Keith Clark <forums-noreply@xxxxxxxx> wrote:
> I have a situation where I need to preload a table of a database with
> values selected from a multiple select report parameter.
>
> I have been able to successfully use the beforeOpen event handler of the
> dataset to modify the sql to write these values.
>
> Problem that I get is the fact that since its an insert command, there is
> not result set, and the dataset throws an exception and stops.
>
> Is there a way to trap the exception, or hide it and continue the report?
You could create a stored procedure that gives a result, e.g 'success',
then use a stored procedure query data set type.

--
Colin

Report message to a moderator

Previous Topic:	Removing a dataset where clause based on parameter
Next Topic:	ODA Designer Plug-In Dev: Parameter Data Type not set / used

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Sep 25 14:41:28 GMT 2024

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter