How execute an insert/update/delete?

Hi.

I'm converting more than 50 reports originally created on Oracle Reports, and now I get a problem: is it possible to execute a insert/update/delete without use SQL Stored Procedure?

I ask that because create all this queries is very prolonged...
For this, I want to execute insert/update/delete with any other way more easy. Is it possible?

Thanks a lot.

Find more posts tagged with

Comments

bhanley

It can be done, but it will require a fair bit of development on your part. You wuill need to implement Java event handlers to respond to the call for the update and handle the actual database interaction.<br />
<br />
Check out this post for a little more background: <a class='bbc_url' href='http://www.birt-exchange.org/forum/designing-birt-reports/14733-interactive-report-user-feedback.html#post46641'>http://www.birt-exchange.org/forum/designing-birt-reports/14733-interactive-report-user-feedback.html#post46641</a><br />
<br />
Good Luck!

brunocobra

Hi bhanley!

Thanks for your reply, but I think that's not solution for me. In many reports, I need to execute an insert/delete/update for each row returned in a DataSet with grouping.

SQL Stored Procedure Query should help me, I think... do you agree?
I'm trying to use, but I'm not having very success...

bhanley

The solution I referenced was a conceptual row-based update strategy, so it should apply to what you are looking to do.

THe trick to what you want to do is in gathering the data to pass to the DB layer. Executing a Stored Proc or a plain SQL update is the easy part. You will need to do some work in either the scripting layer or via Java event handlers to gather the updated data and prepare it for use by the data base either way.

brunocobra

Thanks for help.

Unfortunetally, I have no ideia how do that, but I'm going to search anything like you said.
If you have an example or any article explain that, I'd stay very grateful.

Thanks a lot!

brunocobra

Thanks for your help, Bhanley, but I solved my problem with a SQL Stored Procedures Query.

It works fine.

Very thanks!