Jump to content
Changes to the Jaspersoft community edition download ×

executing multiple SQL statements


2006 IR Open Dicussion

Recommended Posts

By: esauer - esauer

executing multiple SQL statements

2006-02-05 22:01

Is there any way to execute multiple SQL statements? I'm trying to create a temporary table, insert rows, update those rows, and select them in the end, so there is only one select and one ResultSet coming back. I tried correlated subqueries in the FROM clause but this appears not to be implemented in MySQL yet. I'm looking into other solutions but I was just curious. Thanks,

 

Eileen

 

 

 

 

By: cyclistca - cyclistca

RE: executing multiple SQL statements

2006-02-06 09:53

First as a long term developer of reports it's never a good idea to do data processing in a reporting tool. Why don't you do the processing outside of the report?

 

The only way I know of to use mutiple SQL in an iReport is to use Subreports.

 

 

 

 

By: esauer - esauer

RE: executing multiple SQL statements

2006-02-06 14:22

Turned out I didn't need multiple statements this time but I pretty much came to the same conclusion with the subreports. Thanks.

Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Popular Days

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...